Plotting time and distance vs moon phase...

[Steve]

I have a large file (~20,000 rows) of ephemeris data in three columns sorted
by date/time, distance from Earth and Moon phase.

Date is formatted as date, distance is in the order of hundreds of thousands
of km and phase is from 1 to 0.

Time will be on the horizontal axis and the other two series will be plotted
against the vertical, the idea to have two sine wave shaped plots over time.

However, I do not know how to reconcile the scales, if I set the min/max of
the graph between 0 and 1 for phase, then the distance will be off the
scale. If I set the min and max in the order of x00,000 for distance, then
phase does not show.

I'm sure I have seen different scales plotted on the same Excel graph
before. How do I do this? Thanks.

 

[Pete_UK]

They changed it in XL2007. You need to have at least 2 series
(obviously), so select the second series, press Ctrl+1 (numeral one)
to open the formatting dialog, and on the main screen, choose the
Secondary Axis option.

You might find this blog from John Peltier MVP useful:

http://peltiertech.com/WordPress/secondary-axes-in-charts-2/

and the follow up one:

http://peltiertech.com/WordPress/secondary-axes-that-work-proportional-scales/

Hope this helps.

Pete