Directional axis

[Bruce]

I have an XY plot with direction as the X axis and would like to plot data
with North (0 deg) in the centre of the plot. For a half circle, for
example, the X axis values would go from 270 to 90 degrees. The only way I
can get this to work is change the directions "left" of 0 deg on the plot to
negative numbers, plotting from -90 to 90 for my example.

Can anyone suggest a way to plot the actual directions.

Thanks

 

[Jon Peltier]

Bruce -

Convert the numbers in the worksheet to -90 to +90, but use this
technique to add a fake axis with the labels you want:

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

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