Okay so you've mnaged to get the data you need together, organised it an beautiful way but now you need to make that data speak visually, luckily for you, you have stumbled accross this article which is going to show you how to turn your data into some fantastic visual charts. For more in depth reporting you should check out Microsoft Power BI. Lets get to it!
You can use a map chart when you have geographical regions in your data like counties, states or countries. This feature is only available in Office 365 and Office 2019 and will require permission for Bing to access the data. To create the map chart you will need to select a cell iwthin your data range, then select Insert > Charts > Maps > Filled Map
You can use the Waterfall chart to show a running total as values are added or subtracted. To create this chart select any cell within your data range and then select Insert > Charts > Insert Waterfall, Funnel, Stock, Surface, or Radar > Waterfall.
You can use the Funnel chart to show values accross multiple stages in a process. To create this chart select any cell within your data range, then select Insert > Charts > Insert Waterfall, Funnel, Stock, Surface, or Radar > Funnel.
You can use the Bubble chart to visually emphasize specific values with different bubble sizes. To create the Bubble chart select any cell within your data range, then select Insert > Charts > Insert Scatter (X,Y) or Bubble Chart > 3-D Bubble.
You can use the Combo chart to add a secondary axis to show different values than the original axis. To create a combo chart, select any cell within your data range, then select Insert > Charts > Combo > Clustered Column - Line on Secondary Axis.
If this has been useful to you please do share this with your colleagues!