Sum of remove

[bean_2k1]

Hi i have created a plotchart and at the bottom of the chart it is displayed as SUM of SUM of apr 05 etc for all the months is there anyway i can remove the sum of before each month??

thanks

 

[boblarson]

In the query that is underlying it, set the sum column to: SUM:YourFieldNameHere
before the actual field. You should only have to add the SUM: part in before the field name. What you are doing with that is specifying the name returned for the field name (an alias). Otherwise Access chooses it for you based on the aggregate function involved.