Chart axis custom number format

[Chris]

I have a chart with X-axis data ranging from 100000 to
8000000 which is milliseconds. Now what I want to do is
in the display convert it to minutes. So instaed of
saying 100000 I want it to display 16.67 which is
1000000/60000. Is it possible to do simething like this
using custom number format?

 

[Jon Peltier]

Chris -

This is beyond the capabilities of a number format to fix. Insert a
column, put converted values in this column, and use this as your X data.

- Jon

 

[Chris]

Thanks Jon,
I will give that a try.

-----Original Message-----
Chris -

This is beyond the capabilities of a number format to fix. Insert a
column, put converted values in this column, and use this as your X data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______


.