Better way to visualize data?

[kmcdon21]

Hello,

I am hoping someone can think of a better way to present this information. The attached sheet shows three charts that present a 3 year trend of data for multiple individuals (MD1, MD2, etc), and also presents benchmark data for comparison (the horizontal green dotted lines). The underlying data is pulled from pivot tables, and the benchmark figures are static values.

Is there a different chart format I could use to present this data more effectively, or a different layout that could tell the same story with the data perhaps combing into 1 or 2 charts instead of 3? I want to be able to show all of this information on a 1-page printout, so the ability to condense the relevant data is key.

Thanks in advance

 

[chirayu]

Is wRVus in dollars? as chart 2 is numbers not dollars

 

[kmcdon21]

wRVUs are just a number, not dollars. Same for the wRVU benchmark data.
The third chart, collections per wRVU would be in dollars.

 

[chirayu]

See attached sample

 

[kmcdon21]

Chirayu,

This looks awesome and I thought about putting something similar together, but my issue is I need something printable - the dropdowns wouldn't help here.

The issue I struggled with was potentially having both collections and wRVUs on the same chart, with both benchmarks as well. I think it might be information overload though and would be too tough to read. That's why I was reaching out on this forum in case anyone had another format I could present this in.

Thanks for your help

 

[chirayu]

If it needs to be printable then your charts can't really be improved much more unfortunately. Any changes would be merely cosmetic.

 

[r1c1]

As @chirayu suggested, when you need to print the reports, you end up with fewer options. Here is one using dot plots that tries to reduce the complexity of your data. Check out the download workbook.