In an auto-generated chart based on a query (I dragged the chart object onto a blank form to start it), the chart itself is displaying and updating properly, datawise, but I want to change the Legend from reading "SumOfAvgOfield1" and "SumOfAvgOfield2" to regular words suitable for final presentations. But I can't find a way to change it!
A:
I realize this is a late answer, but I was just having a similar issue and figured someone else might benefit from knowing how to get rid of the 'SumOf' labels.
- In design view, right click on the chart and select 'Properties'.
- Choose the Data tab.
- The 'Row Source' field is the one you're going to be interested.
In there you can see various places where it's labeling your data:
Sum() AS [SumOfData]
Just edit the text right in the properties window and you'll be set.
btollett
2010-04-28 23:06:13