Create "Normal" chart object from Pivot Table (XL2000)
Posted by JAF on December 01, 2000 7:08 AM
I have a pivot table that summarises data from a daily input sheet.
What I'd like to do is to create a chart object based on the pivot table data (which is grouped at Month level), but whenever I try to create the chart, it creates a "Pivot Chart" which has 2 fields on it that I don't want (Drop Page Fields Here & Drop More Series Fields Here).
Is there any way of either creating a "normal" chart object from a pivot table in Excel 2000 or at least a way of hiding these unwanted drag and drop fields?
I'm sure Microsoft would call this a "feature", but it's proving to be a real pain in the arse (or ass for any American readers!)