Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / September 2006

Tip: Looking for answers? Try searching our database.

Multiple thermometers in one chart

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tv - 12 Sep 2006 21:41 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.