I would like to create graphs to illustrate the Actual vs. Budget? Any ideas or suggestions

[Rania Alissa]

I would like to create graphs to illustrate the Actual vs. Budget Spreadsheet attached? Any ideas or suggestions regarding what would work best? Feel free to improve the presentation format and make it visually friendly and informative. I am open to suggestions.
The spreadsheet is attached. I also attached a link to an article from Chandoo.org that beautifully shows several graphs. Can anyone show me how to create graph 6 and graph 7 from the spreadsheet data attached? The limitation is that I am using Excel version 7.
Thanks in advance for your inspirations
Rania

Actual vs. Budget Spreadsheet
https://onedrive.live.com/edit.aspx?cid=274120193C510CE1&resid=274120193C510CE1!168&app=Excel

Chandoo: Budget vs. Actual Charts – 14 Charting Ideas You can Use
http://chandoo.org/wp/2009/04/05/budget-vs-actual-charts/

 

[Luke M]

Just to confirm what you wrote, version 7 of Excel? As in, Excel 95??

 

[NARAYANK991]

Hi Luke ,

In an earlier post of hers , Rania has mentioned that she uses Excel 2007.

Narayan

 

[Luke M]

Hi Luke ,

In an earlier post of hers , Rania has mentioned that she uses Excel 2007.

Narayan

Phew, that makes things easier. I was afraid I was going to have to dust off some of my old textbooks.

 

[Rania Alissa]

Luke I appologize for the misunderstanding. I meant Excel 2007. NARAYANK991
is right. He has good memory. Can any of you help? I need ideas especially on how to make graphs #6 and #7 from Chandoo's article with my data spreadsheet attached.
Thanks

 

[Luke M]

Hi Rania,

I can't access your onedrive data, but's here's an example of how to build the charts in #6 and 7. Let me know what you think.

 

[Rania Alissa]

Hi Luke M
I am uploading the data on this sight again. I hope it works.
I appreciate your help
Rania

 

[Luke M]

Here's the charts using your data.