What chart to use for multiple data?

[Paul M]

Hi, I am an excel newbie and wondering if you have any inputs on what chart is best to use to display number of persons per country.

Also how do I cluster the ages in another set of data so I can present it as one.

I have not been able to find enough references on the web as sadly some sites are blocked in my office

Appreciate if you can provide how-to's or a step by step guide as its been very helpful for me to understand excel better when I see an example.

P.S. Im not familiar with VBA/Macros, and still undergoing training for intermediate-advanced excel

Thanks a lot!

 

[Asheesh]

Hi Paul - Check the "Main" Tab..

Does this help...

 

[Areif]

Hi Paul - Check the "Main" Tab..

Does this help...

Hi Paul!
can you explain how you link to the chart of each 10 range, i unable to understand

 

[Asheesh]

Welcome to the Forum...

I am assuming that this question is direct to me and not to Paul, nevertheless..

Go through the below link..

http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/

If you still not able to understand then let me know I will write a detailed write up on this and share with you..

 

[Asheesh]

I found a video that explains it all...

http://www.datapigtechnologies.com/flashfiles/scrollbarchart.html

 

[Areif]

Yes Asheesh my question is for you , i saw a video and got a answer to my question , Thanks for your help

 

[Paul M]

Hi asheesh, this helps a lot. I'm watching the video now and recreating the chart you made. Thank you very much!