graphs in access

[chr1stoper1]

Hi guys

I have been experimenting with my database and have been showing data in reports as data and in graph format which works and looks well. The problem is that if the data is from a query of another query then the graph legends are sumofsumof....... and id like to just have the name of the data instead of sumofsumof is it possible to alter the legend but keep the data source?


Thanks for reading this and thanks for any help

[ranman256]

You can alter the field labels in the query. Just assign it in the query before the colon
MyNewLabel: Sum([field])