All icons on my insert and data tab is greyed out
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.
If this helps, please click the Yes button
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.