I have 6 categories which I am collecting monthly data on. I have a goal for
each.
I would like to create a bar/thermometer chart for each category, showing
monthly progression and show the goal at the top. Can I do this through a
Thermometer, if so, can you tell me how? If not, can you tell me another way
to graph this. Here is a sample of my data.
"Compliance "OPM/CMM
Audits" Integration"
Jan 0 0.5
Feb 1 0.5
Mar 0 0.5
Apr 0 0.25
May 1 0.21
Jun 2 0
Jul 3 0
Aug 5 0
Sep
Oct
Nov
Dec
Total
Complete 12 1.96
Goal 23 2
thanks

Signature
tv
Andy Pope - 13 Sep 2006 09:19 GMT
Hi,
Here is an example of a thermometer chart.
A personally if you are going to have multiple therms I would stick with
the simple design.
http://www.andypope.info/charts/thermometer.htm
Cheers
Andy
> I have 6 categories which I am collecting monthly data on. I have a goal for
> each.
[quoted text clipped - 23 lines]
>
> thanks

Signature
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info