Formulas inside Excel Charts

[jeskit]

Hi

Does anyone know how to control a Chart with a formula?

I have an excel document which has 6 six sheets: a home page, chart page and 4 data pages.

On the chart page i have 9 charts which each connect to data on the data pages. However i also have two drop down boxes. When some changes the drop down boxes i need the charts to refresh with the data relvent to that data.

Does anyone know how to do this without using VBA?

Thanks

Kind regards

Jeskit