All icons on my insert and data tab is greyed out

L

Lily

I was attempting to create a pie chart and clicked the pie chart icon.
However, did not want it embedded in the same Work sheet, so I clicked on the
new work sheet tab. It did not work and somehow I must have triggered
something else and all icons on both my insert tab and data tab is greyed out.
 
S

Shane Devenshire

Hi,

It sounds like you were in 2007? In that case create the chart in the
spreadsheet and then right-click the border of the chart and choose Move
chart. choose the New Sheet option...

Regarding the grayed out items - you are in Group mode because more than one
tab is selected. Right-click any sheet tab and choose Ungroup Sheets.
 
J

jeremy.loe

I was attempting to create a pie chart and clicked the pie chart icon.
However, did not want it embedded in the same Work sheet, so I clicked on the
new work sheet tab. It did not work and somehow I must have triggered
something else and all icons on both my insert tab and data tab is greyed out.
Click to expand...

YES!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Source Data in Chart 3
secondary (Y) axis greyed out on Chart Options 1
Excel 2007 chart help 3
How do I get all 5 graph charts to show data (not be greyed out)? 1
Chart missing in new sheet 4
My Insert Charts Buttons Are Greyed Out...Please Help 1
Series fill only copying and fill series greyed out 1
My chart is not showing; it's all grayed out. 2

Top