Multiple Number Formats

[Anthony]

I have one chart who's data changes based on selections
made. Sometimes the data is a number formatted with zero
decimal places and a comma (ie 1,900). Sometimes the data
is a percentage formatted with zero decimal places (ie
25%).

Is there a way to make this one chart handle both
situations and change the format of the Y Axis based on
the type of data included?

Thanks...Anthony

 

[Jon Peltier]

Anthony -

Try this as a custom number format:

[<1]0%;#,##0

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______