6 Replies Latest reply on Apr 20, 2018 8:36 AM by james.evans.10

# How to create a specialized bullet graph

Alright so basically I am trying to recreate a gauge style graph I saw but with my own data using a bullet graph instead. In my workbook I have measures labeled "A" and "E" and the ratio between the two measures labeled "A/E". The optimal range for A/E is between 0.21 and 1.33 but the A/E ratios range from 0-186 so I would like to create a bullet graph that I can use dynamically to drop in any individual ID number and see where the A/E ratio falls (inside or outside the desired range). Essentially I want to be able to keep the range constant and be able to drop in any ID number and see where it falls into the range. Can anyone help?

• ###### 1. Re: How to create a specialized bullet graph

Hi James,

No exactly sure, but something like this?

fyi

Thanks,

shin

• ###### 2. Re: How to create a specialized bullet graph

Hi, James

Is it something like this? if yes, pleas find attached workbook.

Hope this helps

ZZ

• ###### 3. Re: How to create a specialized bullet graph

Hi Shinichiro,

Not quite, I drew up an example of the viz I want to create the clarify a bit better. The extreme "A/E" values don't matter as much so something like the attached picture would work great as a sort of background or constant image. Then I might be able to drop an ID into the view and see where it falls on the range.

• ###### 4. Re: How to create a specialized bullet graph

Hi Zhouyi,

Not quite, I want to create something like this picture I drew up, the extreme values don't matter as much as the optimal range of 0.21-1.33 so if I could somehow create this image as a constant and then be able to drop an ID into the view and see where it falls into this type of range it would be perfect

• ###### 5. Re: How to create a specialized bullet graph

Hi, James

Please find my updated workbook attached.

ZZ

1 of 1 people found this helpful
• ###### 6. Re: How to create a specialized bullet graph

That works, Thanks!