I use excel 2002 now but used an earlier version which didn't force me to use
the pivot charting process if I wanted to create graphs.
I have my pivot, I click on the graphing icon and the chart appears but I
don't have access to source data in the usual excel graphing format other
than drop down data on the side or bottom of the pivot chart.
Even the data data doesn't list sequentially
MONTH (dd/mm/yyyy)
01/04/2007
01/03/2007
01/01/2007
01/02/2007
Is there a way I can disable the pivot chart and use the regular excel
charting process?
Bill