I have a simple stacked column chart on an Access report, with a data table. The numbers on the data table are in millions, and COMMAS would make it a lot more readable. I have tried everything I can think of. I can format the X and Y axes and legends and titles, etc., but not the numbers in the data table. Anyone have any suggestions?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I format numbers on a data table in an Access chart?
- Thread starter kubanvz
- Start date
- Thread starter
- #2
Nvermind. I figured it out. I am posting the solution just in case someone else has the same question. I went into the row source property of the chart and used the Format function on my number field, with the format of "##,##0", and it worked.
- Status
Similar threads
- Locked
- Question
- Locked
- Question