Chart axis help
 

Hello all

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

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

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


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



Cheers
Nobby

Chart axis help
 

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/...Gridlines.html

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


"nobbyknownowt" wrote in message
...

Hello all

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

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

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


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



Cheers
Nobby


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



--
nobbyknownowt

You're correct I did miss it

Jon you are an excel god!

thanks
nobby