Solved: Charts - Using Two Y Axes

[peacenik]

This is not a VBA question, but hopefully, someone can help me.

I am trying to compare two sets of data that have very different scales. I want to be able to show one on the left hand axis and one on the right hand axis but don't know how to do it

Thanks in advance.

[TrippyTom]

Look here:
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

[peacenik]

Thanks, that did exactly what I needed.