Chart Wizard Grayed Out

Hello Experts!

In Office 2003, for an excel file, the icon for the chart wizard is grayed out.
Also, Insert --> 'chart wizard' is also grayed out.

Even if I created another worksheet in the file, the chart wizard is grayed out.

Is there any reason why it's grayed out? Can we still use chart wizard?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

zorvek (Kevin Jones)ConsultantCommented:
Is the workbook shared? If so you will not be able to instert charts. You will have to unshare the workbook to do so.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
allanau20Author Commented:
Oh. You're great. It think it has to do with shared b/c it's on the network drive and I just copied it. How can I tell if it's share and how can it be disabled? Thanks!
zorvek (Kevin Jones)ConsultantCommented:
Tools->Share Workbook and uncheck "Allow changes by ..."

Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

allanau20Author Commented:
WoW Ho. You're the best. Thanks for the quick help!
Patrick MatthewsCommented:
Hi allanau20,

By the way, it is a super bad idea to use that 'share workbook' functionality.  The consensus opinion here is
that it makes workbooks too vulnerable to coirruption to be worthwhile.  If you really need to allow multiple
people into the file at once, use a real database app instead.


allanau20Author Commented:
Um Thanks mathewspatrick. Sorry can't give you any more points for your comments.

Have a great day!
Patrick MatthewsCommented:
> Sorry can't give you any more points for your comments.

No worries, I wasn't looking for any :)


It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.