ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Variance analysis (https://www.excelbanter.com/charts-charting-excel/256666-variance-analysis.html)

Jens

Variance analysis
 
Is there any application or add-in to make a chart like this without having
to do a lot of manipulating figures and chart?

Opening value for instance 10
Growth coming from prices +3
Volume growth -1
New accounts +4
Closing value 16

This is normally shown in a bar graph like stairs - if you understand what I
mean.

Bernard Liengme[_2_]

Variance analysis
 
See
http://peltiertech.com/Excel/ChartsHowTo/StepChart.html
best wsihes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Jens" wrote in message
...
Is there any application or add-in to make a chart like this without
having
to do a lot of manipulating figures and chart?

Opening value for instance 10
Growth coming from prices +3
Volume growth -1
New accounts +4
Closing value 16

This is normally shown in a bar graph like stairs - if you understand what
I
mean.




All times are GMT +1. The time now is 03:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com