plotting a single data series with two different units

[jbrandt]

Hello all,

Let's say I have a data series of GPS displacement values over time.

date | North | East | Up | adj (m) | adj (ft)
2/11/2000 -2591457.302 -4548112.793 3633016.7537 0.0000 0.0000
2/12/2000 -2591457.309 -4548112.792 3633016.7556 0.0019 0.0062
2/13/2000 -2591457.309 -4548112.808 3633016.7676 0.0139 0.0456
2/14/2000 -2591457.31 -4548112.816 3633016.7837 0.0300 0.0984


I want to plot "up" (vertical) on a graph, with one side showing feet, and the other showing meters. I've tried having two separate data series (as shown above), and have one of them as a secondary axis, but the plots don't line up.

All I really want is a single plot, but meters on one side, feet on the other...

Kind of like this, but with one line...
http://farm7.static.flickr.com/6182/6052845255_2dcbc09d93.jpg

thanks in advance

 

[Steve=True]

The sample you provide don't line up either.

You can set your second axis and first axis to the min and max you want that will make them line up.

Excel sets its own limits that may not be what you want.


Steve=True
www.exceldashboardtemplates.com

 

[Jon Peltier]

Plot your data on one axis, then plot any dummy point in a second series, just enough to put on the secondary axis. It doesn't have to mimic the primary series. Hide this point (no marker, no line, etc.).

You can't rely on Excel's axis autoscaling. Manually scale the primary axis to fit the data. Manually scale the secondary axis so its min and max are related to the primary min and max by the conversion factor.