Multiple Units on Chart Axis

[tydguy17]

Hi, I need ideas on how to display a Metric and Imperial units on a chart. The problem is I need to somehow show these on the primary AND secondary axis. The chart is showing a comparison of pump performances with speed curves and an expected output torque.

Y1 Axis: Output Speed (RPM)
Y2 Axis: Output Torque (ft-lbs AND N-m)
X1 Axis: Differential Operating Pressure (PSI AND KPa)

I need to generate +150 graphs so having a result that can be automated (macro) would be great. I thought of overlaying a second chart, but I have no idea how I can line up the axis exactly, and keep it lined up as the graph changes.

Any ideas?

 

[gardnertoo]

You can create custom gridlines (one for multiples of Imperial units and one for multiples of Metric) and add custom labels to each. The big-picture: you create a new series of points on the Y axis where X=0 and Y increments every 10 ft-bls (for example) and a second series where X=0 and Y increments every 10 N-m. Plot those points on the chart, create positive X error bars to stand in for the default gridlines, then delete the default gridlines. Same thing on the X axis for 100 PSI and 1000 KPa. For a step-by-step example, follow this link to the Peltier Technical Services web site.

 

[tydguy17]

Thanks! This is working for me. That is a great website. For other people's reference, I also found this link which is helping make my labels dynamic.

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