#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 563
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Variance Analysis and Excel Mur Excel Worksheet Functions 1 January 6th 10 08:55 PM
Excel Formula and Variance Analysis Mur Excel Worksheet Functions 0 January 6th 10 06:57 PM
analysis of variance with lack of fit in excel Bob Excel Worksheet Functions 2 October 4th 07 06:37 AM
Pivot Table Subtotals/Variance Analysis NCW Excel Discussion (Misc queries) 1 August 6th 05 07:23 PM
Pivot Tables - Variance and % Variance fields CraigS Excel Discussion (Misc queries) 5 January 6th 05 12:22 AM


All times are GMT +1. The time now is 07:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"