button grayed out for Charting

I am trying to use the Chart Wizard or the Chart Toolbar to create a chart.
However, both are greyed out.



Any idea why or what I should do to fix this?

thanks,

Ron

Usual suspects are protected workbook or worksheet. Shared workbook.

rgraham1 wrote:
> I am trying to use the Chart Wizard or the Chart Toolbar to create a chart.
> However, both are greyed out.
>
>
>
> Any idea why or what I should do to fix this?
>
> thanks,
>
> Ron
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks for the fast reply Andy.

I've checked in the Tools Command under Protection and Shared, but see
nothing to indicate any restrictions. Could you offer any specifics?

You should know that this spreadsheet has a history of being created by me
on my Windows computer first. Being emailed around to a half dozen people in
my Group. I have copyed and pasted the updated data from those 6 people that
emailed me their updated spreadsheets. I now have one spreadsheet with all
of the data they have emailed to me combined into one spreadsheet.

It's this final spreadsheet that I am now not able to create the Charts with.

Does that help?

thanks again,

Ron



"Andy Pope" wrote:

> Usual suspects are protected workbook or worksheet. Shared workbook.
>
> rgraham1 wrote:
> > I am trying to use the Chart Wizard or the Chart Toolbar to create a chart.
> > However, both are greyed out.
> >
> >
> >
> > Any idea why or what I should do to fix this?
> >
> > thanks,
> >
> > Ron
> >
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>

Another option is grouped sheets.


rgraham1 wrote:
> Thanks for the fast reply Andy.
>
> I've checked in the Tools Command under Protection and Shared, but see
> nothing to indicate any restrictions. Could you offer any specifics?
>
> You should know that this spreadsheet has a history of being created by me
> on my Windows computer first. Being emailed around to a half dozen people in
> my Group. I have copyed and pasted the updated data from those 6 people that
> emailed me their updated spreadsheets. I now have one spreadsheet with all
> of the data they have emailed to me combined into one spreadsheet.
>
> It's this final spreadsheet that I am now not able to create the Charts with.
>
> Does that help?
>
> thanks again,
>
> Ron
>
>
>
> "Andy Pope" wrote:
>
>
>>Usual suspects are protected workbook or worksheet. Shared workbook.
>>
>>rgraham1 wrote:
>>
>>>I am trying to use the Chart Wizard or the Chart Toolbar to create a chart.
>>>However, both are greyed out.
>>>
>>>
>>>
>>>Any idea why or what I should do to fix this?
>>>
>>>thanks,
>>>
>>>Ron
>>>
>>
>>--
>>
>>Andy Pope, Microsoft MVP - Excel
>>http://www.andypope.info
>>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Are you editting a cell?
rgraham1 Wrote:
> I am trying to use the Chart Wizard or the Chart Toolbar to create a
> chart.
> However, both are greyed out.
>
>
>
> Any idea why or what I should do to fix this?
>
> thanks,
>
> Ron


--
jahoobob

I wasn't able to determine the cause of the "graying out" situation, so I
just created a new worksheet and copied and pasted the data into it. Not
eligent but it worked.

thanks for the good suggestions,

Ron



--

Ron



"jahoobob" wrote:

>
> Are you editting a cell?
> rgraham1 Wrote:
> > I am trying to use the Chart Wizard or the Chart Toolbar to create a
> > chart.
> > However, both are greyed out.
> >
> >
> >
> > Any idea why or what I should do to fix this?
> >
> > thanks,
> >
> > Ron
>
>
> --
> jahoobob
>

See, it must have been a corrupted worksheet, he he!

- Jon

rgraham1 wrote:

> I wasn't able to determine the cause of the "graying out" situation, so I
> just created a new worksheet and copied and pasted the data into it. Not
> eligent but it worked.
>
> thanks for the good suggestions,
>
> Ron
>
>
>