How to customize Access Chart Series Names

[Cl0n3Tr00per]

How do you change the series names on an Access 2007 chart? I inserted a chart within my subform, and besides looking ^$$ UGLY, it displays my field names as SUMOFTHIS and SUMOFTHAT.

I'm showing a linechart with 3 source fields: MonthlySalesQuota, MonthlyActualSales, and MonthlyPipelinePending.

I couldn't find a way to customize the multiseries line chart to allow me to drag the 3 fields on the series box to the right of the wizard. Only the SUMOF at the top allowed me to add multiple series...

Found how to change most things to make the charts more palatable, except for the series actual display name.

Any Ideas??

 

[wiklendt]

http://www.vb123.com.au/toolbox/09_access/access2007charting.htm

edit: once you get into the chart edit section, you can edit bits exactly the same as you can in excel. just click on it and it will allow you to edit. i just tried it myself works!