• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Been trying to re-create this bullet style chart forever any ideas?

Thna
Check out Jon Peltier's web site. Here is a link to his discourse on Bullet charts

https://peltiertech.com/bullet-charts-in-excel/

Thanks for the reply!
Been there many times, problem with bullets is they start on 0,and too complicated for my chart. I need to start and end on Hi/Low. All base bars can be same size, just the label changes depending on hi/low.

So, consists of:
1-Same size bar labeled with hi and low
2-A range overlay of +1/-1 Std. Deviation
3-The latest #
4-An arrow or some way to show current trend up or down

Should be easier than most bullets I have seen, just not an excel chart expert.

Thanks
 
I am not much of charter myself. I do have a spreadsheet (attached) that demos how to make a thermometer chart. You might be able to modify to meet your needs.
 

Attachments

  • Thermometers.xls
    377.5 KB · Views: 5
Hi Lal Echterhoff,

You should have uploaded a sample file and your trial of the chart with representative data as per forum rules. It allows us to help you faster and better.
Concerning min/max, that can be achieved with a stacked column or bar chart.
Made something like this. Could be a starting point.

upload_2018-11-29_8-48-54.png
 

Attachments

  • chandoo 40177.xlsx
    14.4 KB · Views: 0
with values and reversed the axis of plotted series, perhaps closer to what your are after?
upload_2018-11-29_13-28-26.png
 

Attachments

  • chandoo 40177.xlsx
    15 KB · Views: 6
Back
Top