Chart Actual vs Budget

[Samir69]

Dear All,

I am interested by the charts #8 and #7 of the link below.

Do you know how i can build the chart which show the variation in % and in absolute value ?

Thanks

http://chandoo.org/wp/2009/04/05/budget-vs-actual-charts/

 

[Hui]

Samir69

An example of No 7 is shown in the attached
I believe No 8 was done using an Excel addin from the guy who posted the example

 

[GFC]

Some Excel Templates can be downloaded at:
http://www.hichert.com/consulting/schaubilder/453#017

 

[Samir69]

Hello Forum,

Thanks Hui for your proposition. One question how did you integrate the round and how can we color the round in green if we have a positive variation and in red if we have a negative variation ?

Thanks GFC for your very interesting link

 

[Somendra Misra]

Hi Samir,

The round are the END type which you can select in more error bar options. As to turining it to green if goes positive, please have a look of attached file. I had used two dummy series to create this chart.

Regards!

 

[Samir69]

Thanks a lot Somendra

 

[Inna Zubko]

Hi,

Is there are way to integrate those data tables (Actual/budget) within the graphs, so it looks more like #7? thanks

Inna

 

[aparvez007]

Hi Sameer69,

May be this chart will help you. Thanks to Faseeh for this chart.

 

[Samir69]

Hi Aparvez

Many thanks for this chart, very interesting. Thanks Faseeh for your help

 

[elko]

http://chandoo.org/wp/2009/04/05/budget-vs-actual-charts/

Hello

Could someone post chart 8 and 14 from this subject