Chart axis help

[nobbyknownowt]

Hello all

I have written an excel sheet with chart to plot the center of gravit
position on an aircraft. I plan to pdf the excel sheet for printing an
manual completion as well as have an identical computer versio
available.

The fly guys want the axis to be clearer (easier to read in dark) an
ideally have the two X axis away from the Y axis I have currentl
completed this by extending the Y axis and manually editing the char
before printing. (see jpeg top without the highlight circles is what
want, bottom is what i currently have) This is OK for the manua
version but I also want the computer version to work.

I have seen the arbitary axis scale method but to enter each incremen
on my x axis primary and seconsary I would run out of data series.


Any thoughts would be gratefully received, pulling what little hair
have left out !!



Cheers
Nobb

+-------------------------------------------------------------------
|Filename: envelope edited example.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=121
+-------------------------------------------------------------------

 

[Jon Peltier]

I have seen the arbitrary axis scale method but to enter each increment

on my x axis primary and secondary I would run out of data series.

You missed the example where all the X values are in one series and all the
Y values in another?

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

- Jon

 

[nobbyknownowt]

You're correct I did miss it

Jon you are an excel god!

thanks
nobby


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+