changing x-axis in a chart

[alldreams]

I use the DOLLARFR(B10,32) worksheet funtion to convert a
base 10 number to base 32. However, when I make a chart,
the series for B is plotted against the x-axis as if we
were base 10. i.e. if B10 = 112.30 (which in base 10 is
112.97) it appears in the chart closer to 112 than 113.

Do you know how in VBA I could change the chart x-axis to
plot in base 32?

Thanks for your help!

 

[Tom Ogilvy]

The x-axis in an xy scatter plot will be plotted in Base 10.

 

[alldreams]

so there is no way to change this in VBA?

-----Original Message-----
The x-axis in an xy scatter plot will be plotted in Base 10.

--
Regards,
Tom Ogilvy






.

 

[Tom Ogilvy]

VBA offers no additional settings beyond what is available manually.

 

[Jon Peltier]

Excel's natural axes can only work in values in base 10. But you can
fake it, using an Arbitrary Axis Scale:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

- Jon