I am trying to format a chart where the data axis is a dollar amount that ranges from the $100K's into the $1M's. However when I try to format the axis using the 'number format' within the chart expert, when the number goes beyond the number $999K and hits a million - the number format remains as a $1,000K - it doesn't switch it over to $1M like it should. Does that make sense? This has me stumped. (-:
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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data axis number format...
- Thread starter Notavg1
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question