Hi,
I have some simple data and I wish to create normal charts from summarised pivot table data. I use pivot tables as the data is a few 1000 rows long and they are convenient. I can add 2 columns from the pivot table to a normal chart series without referencing the pivot table headers fine. As soon as I try to move one of my series by pressing a move row/column buitton, the NORMAL chart turns into a PIVOT chart without me wanting it too. Is there any way to stop pivot charts kicking in? If not, is there any other way to easily summarise a few 1000 rows of data so that multiple normal charts can be created from it, your ideas would be most welcome.
Thanks
Paul
My simple data for example:
Product Weight Row Labels Sum of Weight
AA 1 AA 2
BB 2 BB 4
CC 3 CC 6
AA 1
BB 2
CC 3