I'd like to create a thermometer chart with 2 Y axis but can't for the life
of me figure out how to get the 2nd axis to appear on a single bar,
thermometer style chart.

For example, say I need to sell 100 widgets this year. Those 100 widgets are
broken down into monthly quotas. Say, 13 in Jan, 8 in Feb, 10 in Mar, etc.

I'm not concerned with tracking my monthly quotas. I just want to know my
year to date progress against the annual plan. So for example, I don't care
whether or not I sell 8 widgets in February. I only care that by the end of
February I need to be at 21 total YTD.

I want the left side of the chart (Y1) to display the numbers 1 - 100. The
right side (Y2) should display the months (Jan - Dec). Each month on Y2
should line up with the appropriate number on Y1. (Using the quota numbers
above, Jan would line up with 13, Feb with 21, Mar with 31, etc).

The X axis is simply my YTD progress.

Basically a simple thermometer chart is great for displaying progress
against an overall goal, but it doesn't give you milestone goals along the
way. I want to look at it know where I need to be at the end of any given
month so that I can track whether or not my progress is on schedule.

Does that make sense?