I am having a major problem trying to create a thermometer chart. I am looking to create a guage that shows if the actual reserves meet the minimum needed. Any advice is greatly appreciated because I've been racking my brains out for hours.
I am having a major problem trying to create a thermometer chart. I am looking to create a guage that shows if the actual reserves meet the minimum needed. Any advice is greatly appreciated because I've been racking my brains out for hours.
One way would be to use column chart with 2 series. Move 1 series to the secondary axis.
This will allow you to alter the column thickness.
Remove secondary vertical scale to ensure all data uses the same scale.
What do you want it to look like?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
So you need 4 separate thermometer chart?
May be something like below?
0.JPG
Though personally I prefer bullet chart to thermometer.
See attached. It uses single axis with Series overlap set to 100%.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Thank you all for the responses. Attached is what I meant by a thermometer chart. It's the chart used in Michael Grohhs dashboard and I wanted to basically have it land on green if I stay at 100% or above of the minimum and go to red if it goes below 100%. Sorry for the confusion. I'm just very confused on how to do this. I tried editing the data series on all portions and nothing has worked whatsoever.
Oh, you mean gauge chart.
I'm not a fan of these type of chart, it's not at all conducive to visualizing data. My preference here is bullet chart.
Have a read of...
https://peltiertech.com/not-gauges-again/
You can read about how to create gauge/speedometer chart in link below.
https://chandoo.org/wp/excel-speedom...hart-download/
Wow... that's actually much better than a gauge chart... I hate that it won't let me add to your reputation again today! Thank you so much!!!
You are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks