Graphical Representation of data

[anil.ishaq]

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

 

[Stiuart_W]

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]

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.

	Base	Fall	Rise
Start		0	4000
Jan	4000	0	1707
Feb	4282	1425	0
Mar	3252	1030	0
Apr	3252	0	1812
May	3997	1067	0
Jun	2516	1481	0
Jul	2516	0	1228
Aug	3744	0	1176
Sep	4920	0	1146
Oct	6066	0	1205
Nov	5883	1388	0
Dec	5883	0	1492
END	7375

<tbody>
</tbody><colgroup><col span="4"></colgroup>

This is an example of the type of data I use...

Start		0	4000
Jan	4000	0	1707
Feb	4282	1425	0
Mar	3252	1030	0
Apr	3252	0	1812
May	3997	1067	0
Jun	2516	1481	0
Jul	2516	0	1228
Aug	3744	0	1176
Sep	4920	0	1146
Oct	6066	0	1205
Nov	5883	1388	0
Dec	5883	0	1492
END	7375

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