Hi - I am looking for some assistance on how to display a set number of IT Assets, each with its own fixed criticality rating - each asset also has a Compliance rating which can change depending on a separate calculation. I wanted to create something better than say a bar chart for a report - I was thinking bubble chart maybe ? Not sure as this pretty much is Risk mapping for the asset - I am trying to get away from the mundane boring high medium low impact view ?
Looking for ideas and assistance get me started. Thank you (attached)
Hi Mike,
I'm not sure I understand your data. I've assumed the 'Assets' column is the asset ID, as opposed to the number of assets.
I understand the desire to create a chart that's not boring, but it must also be quick and easy for the user to read, otherwise it defeats the purpose of charting the data.
I don't think a bubble chart will work as it requires a third value for the bubble size. In the attached file is a scatter chart, column chart and a radar chart. I don't recommend the radar chart at all as it's very difficult to understand. Personally I think the column chart is the clearest for the user to interpret at a glance.
I hope that gives you some ideas.
Mynda
