ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Possible chart model? (https://www.excelbanter.com/charts-charting-excel/195294-possible-chart-model.html)

Roberto (Brazil)

Possible chart model?
 
I want to make a new model of chart, i donÂīt no is or not possible.
I seed that in a company presentation, but maked it with two grups os value
and is very dificult to atualized.
Imagine the sample below with colums:

Ebit 2007 price volume cost expenses EBIT 2008
15 +5 +2 -3 -2 17

but the "price" begin your colum in the top line of "Ebit 2007", the next
colum "volume" begin in scale 20, because is 15 + 5 for a price, the next
"cost" must the top of the colum at the number 22 and go down 3....

chart:
xxxxx
xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxx
xxxx
xxxx
xxxx
ebit price volume cost







Jon Peltier

Possible chart model?
 
Do you want a Waterfall Chart?

http://peltiertech.com/Excel/Charts/Waterfall.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Roberto (Brazil)" <Roberto wrote in
message ...
I want to make a new model of chart, i donīt no is or not possible.
I seed that in a company presentation, but maked it with two grups os
value
and is very dificult to atualized.
Imagine the sample below with colums:

Ebit 2007 price volume cost expenses EBIT 2008
15 +5 +2 -3 -2 17

but the "price" begin your colum in the top line of "Ebit 2007", the next
colum "volume" begin in scale 20, because is 15 + 5 for a price, the next
"cost" must the top of the colum at the number 22 and go down 3....

chart:
xxxxx
xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxx
xxxx
xxxx
xxxx
ebit price volume cost










All times are GMT +1. The time now is 02:29 AM.

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