Dynamic charts

[justdream]

Dears,

Do you know how to create dynamic charts in Excel as shown below:

http://www.xe.com/currencycharts/?from=EUR&to=USD

[CatDaddy]

that is really cool, i would like to know how to do this as well! I will work on it today and let you know if i come up with anything

[justdream]

Good luck, wish you the best

[justdream]

Experts,
do you think we could do it using Excel??

[Capungo]

Hello All,

I am not an Excel Guru. But I believe I can do a dynamic chart like this by using the Query, Pivot Table and Pivot Charts. If the data will be connected to a web data source, you have to use External Data Source abilities of Excel. The rest of it is pretty easy...

I'd advice you to make a research on Excel Web Queries...