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

I am trying to assign resources to tasks but the 'Assign Resources' is greyed out on the Resource tab. 0
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Save is Greyed Out 1
Where Did My Graph Go, Please ? 0
Change Source Data in Chart 3
Print charts in a 30 tab workbook 3
Mailmerge and Charts 0
secondary (Y) axis greyed out on Chart Options 1

Top