Secondary Y axis in xl2000

[ff_emt1]

I have done some searching and have not found an answer to this problem.

First, I have Excel 2000. If it can be done in a later version and not 2000 there is a slim chance I can get upgraded.

Create a graph with 2 data points. I can insert a picture today, but they are the same picture, just a tall one and a short one.

Here is what I want to do. Create a graph with 2 thermometers, or maybe hour glasses, both the same size. The background empty picture is static, just the mercury or sand will change. The first one shows last years results as a percentage, 100% and the thermometer is full. The second one will display a year to date rising total. Thermometer increases the mercury level, the hour glass will decrease the sand in the top and increase the sand in the bottom.

If that is possible, how about this. Somehow use the Conditional Format command to change the color, blue for within goal range, red if over.

Any ideas?

If not in Excel, any Excel add-in you are aware of that might help.

Thanks ahead of time for your input.

Bob
Quality Facilitator
Kendallville, Indiana

 

[Andrew Poulsom]

Here are some thermometer charts:

http://www.andypope.info/charts/thermometer.htm