L
Legacy 63186
Guest
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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Excel Facts
What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
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
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
Upvote
0
Similar threads
- Replies
- 5
- Views
- 470
- Replies
- 3
- Views
- 577
- Replies
- 0
- Views
- 292
- Replies
- 3
- Views
- 657
- Replies
- 8
- Views
- 351
