X axis labels

[Legacy 63186]

Does anyone know if it's possible to change the x-axis labels on a chart. I have created a chart that has lables on the x-axis showing sumofavgoffield44 instead of this i'm wanting to put A.

 

[AllyBally]

Yes you can very easily.
Open the report or form in design mode that contains your chart.
Right click on the chart and select Properties.
On the Row Source click on the button with the three dots at the end of the SQL statement which will open the SQL as a conventional query
In the field that you have set to sum insert A: before the actual field name in the grid and then close the query clicking on Yes to save the updated SQL. Your category will now appear as A
Regards,

Alain

Charts in Access are a real pain in the BXXT