Hi,
I am only used to Win97/2000 Excel and I am struggling with some basic functionality.
When I create a pivot table I don't seem to be able to view the grand totals in my chart associated with the pivot table.
Therefore, I can't run a grand total/trendline against one axis and all the other series on the other axis.
I know this must be something obvious I haven't done but I am stumped for now!?
Cheers, Alistair
I am only used to Win97/2000 Excel and I am struggling with some basic functionality.
When I create a pivot table I don't seem to be able to view the grand totals in my chart associated with the pivot table.
Therefore, I can't run a grand total/trendline against one axis and all the other series on the other axis.
I know this must be something obvious I haven't done but I am stumped for now!?
Cheers, Alistair