Thermometer chart with 2 Y axis?
 

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?

Thermometer chart with 2 Y axis?
 

Hi,

The simplest way is to use a extra data series plotted as xy-scatter.
The X values will place the points on the right side of the plot area.
The Y values will be the total required for each month.
The use the data labels to display the actual month names. Use Rob Bovey's
chart labeler to allow you to easily link cell contents to data labels.

http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jason" wrote in message
...
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?

Thermometer chart with 2 Y axis?
 

Thanks Andy. This helped, and I'm getting closer, but I don't understand how
to plot all of the points in a single verticle line on the right side of the
plot area. The points are in the correct location on the Y axis but they're
still spread from left to right on the X axis.

"Andy Pope" wrote:

Hi,

The simplest way is to use a extra data series plotted as xy-scatter.
The X values will place the points on the right side of the plot area.
The Y values will be the total required for each month.
The use the data labels to display the actual month names. Use Rob Bovey's
chart labeler to allow you to easily link cell contents to data labels.

http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jason" wrote in message
...
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?

Thermometer chart with 2 Y axis?
 

Hi,

That would suggest 1 of 2 things.
You used a line chart rather than a xy-scatter.
You are using default X values because you have not defined a range for the
series to use.

If you are still having problems you can email me an example and I will have
a look see.
andy AT andypope DOT info

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jason" wrote in message
...
Thanks Andy. This helped, and I'm getting closer, but I don't understand
how
to plot all of the points in a single verticle line on the right side of
the
plot area. The points are in the correct location on the Y axis but
they're
still spread from left to right on the X axis.

"Andy Pope" wrote:

Hi,

The simplest way is to use a extra data series plotted as xy-scatter.
The X values will place the points on the right side of the plot area.
The Y values will be the total required for each month.
The use the data labels to display the actual month names. Use Rob
Bovey's
chart labeler to allow you to easily link cell contents to data labels.

http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jason" wrote in message
...
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?