I have a multi-pivotchart I am using to display data. Each chart shows a score for the month (taken from the date field). What I would like to do is display the three month average as a fourth column in each chart. (or at least the average alone since I only show 3 months anyways) i.e. jul, aug, sept, ave
I have an average column under grand total in pivot table view but I cannot seem to translate this into a pivotchart that displays what I describe above. I do know this is far easier with MSGraph but I want to use pivotcharts for various reasons. Any help is greatly appreciated.
I have an average column under grand total in pivot table view but I cannot seem to translate this into a pivotchart that displays what I describe above. I do know this is far easier with MSGraph but I want to use pivotcharts for various reasons. Any help is greatly appreciated.
