Graphical Representation of data

anil.ishaq

Board Regular
Joined
Aug 18, 2011
Messages
82
Hi All,
I’m trying to search useful charts or ways to visually show a representation of my data set. So I’m trying to show the end user the flow/story of what the data represents so key decisions can me made off this. I’ve learnt waterfall charts from this link - How to create waterfall chart in Excel 2010 - 2013
Does anyone know of better ways of visually presenting my data so I can include it in presentations?

Thanks,
Anil
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Stiuart_W

Well-known Member
Joined
Jul 3, 2013
Messages
516
You're going to have to tell us quite a bit more about the data that you're trying to present. Maybe even upload to a file share an example of the data
 

anil.ishaq

Board Regular
Joined
Aug 18, 2011
Messages
82
Well I'm trying to show the change of data from an opening balance and closing balance at the end of the year. The waterfall chart shows the rise/falls of the changes month on month. I never knew about waterfall charts before last week and now I've started to include them in my presentations with my budget holders. I thought I'll ask a rather general question in case anyone from their world of work uses various charts or ideas to represent their data.
BaseFall Rise
Start04000
Jan400001707
Feb428214250
Mar325210300
Apr325201812
May399710670
Jun251614810
Jul251601228
Aug374401176
Sep492001146
Oct606601205
Nov588313880
Dec588301492
END7375

<tbody>
</tbody><colgroup><col span="4"></colgroup>
This is an example of the type of data I use...






















































































Start04000
Jan400001707
Feb428214250
Mar325210300
Apr325201812
May399710670
Jun251614810
Jul251601228
Aug374401176
Sep492001146
Oct606601205
Nov588313880
Dec588301492
END7375

<colgroup><col width="64" style="width: 48pt;" span="4"></colgroup> <tbody>
</tbody>
 

Watch MrExcel Video

Forum statistics

Threads
1,122,517
Messages
5,596,620
Members
414,081
Latest member
Subaru_Steve

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top