Can I change the source data to a chart automatically?

[KOLM#S]

I have a table that consists of 4 - 10 names (rows) and 3 - 10 headings (cols)

The table data changes when user selects the optios from two drop-down boxes....

Is there any way to change the source data automatically....

hope this makes some sense....

All the best KOLM#s

 

[PaddyD]

you need to drive the chart with (dynamic) named ranges, ahve a look here for explanations of the technique / examples:

http://www.peltiertech.com/Excel/Charts/Dynamics.html

http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html