Best way to do this chart or table or whatever i should use

[hollyse]

I have a stacked column chart that shows active incidents by stacked by Updated 5+ Days Ago- True/False. Green is false and red is true. I also would like it to show incidents tha have been opened 30+ Days. What would be the best way to do this and how would it be done? Maybe a way to add yellow for Opened 30+ Days and Orange if both Opened 30+ Days and Updated 5+ Days ago?

[Anonymous · Accepted solution]

Hi @hollyse ,

Has your problem been solved?
If you have found suitable solutions, please share them as it will help more users with similar problems.

And don't forget to accept the answers. Your action would be helpful to other users who encounter the same issue and read this thread. 🙂

Thanks for your understanding!

Best regards,

Lucy Chen

[hollyse]

It hasn't really been solved yet, but that is ok, i will make something work 🙂

[lbendlin]

what is a bullet graph? — storytelling with data

[lbendlin]

If your secondary data is always a subset then you can consider this approach

How to Create a Column Chart Within Another Column Chart – HowtoExcel.net

But be careful not to cram too much into a single visual.

[hollyse]

Hmm...not sure either will work. I have this, but still thinking there is a better way. So what i am wanting to show is all Active incidents, and which of those active incidents haven't been updated for 5+ Days and/or have been open 30+ Days. All i could get to work is stacked with slicer:(