IT Management & SupportMicrosoft 365 ServicesSharepoint DesignAutomationCyber SecurityCollaborationContact Us

5 Amazing Charts You Can Make in Excel

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!

1) Map

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

2) Waterfall

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.

3) Funnel

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.

4) Bubble

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.

5) Combo

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!

Click here to download

More news...

Copyright © 2021 ARVITENI. All rights reserved. ARVITENI is a company registered in England and Wales with Company Number: 12255133
VAT: 340921227

Our industry partners