Alex has attended:
Excel Advanced course
Pivot table
I have created a pivot chart and am adding data to be plotted using the pivot table list. However, when I drag item 1 into the data area it plots it as a count. I can change this by double clicking and setting it to sum, rather than count, but if I add item 2 it automatically goes in as a count and I can not double click on the tab above the graph as once you add more than one data items the tabs (that I need to click on to change count to sum) disappear and all I get is a legend. Unfortunately I cannot double click and change the type to sum and all additional data items automatically go in as
RE: Pivot table
Ok, try to use the field setting interface to modify this.
One way is to right click on the field you want to modify, then choose field settings.
Another way is to select the field, and then click the field settings button on the pivot table toolbar
Let us know if that works for you.
