Hello,

I am wanting to display data from different sheets in chart form on sheet 1. A drop down list will also need to be linked to the chart in order to select which data is to be displayed.

After reading various help guides and blogs, I now understand that I need to use interactive charts.

I found a guide similar to what I want to achieve at http://peltiertech.com/Excel/Charts/ChartByControl.html, however he is using dual-lists and was a bit too complicated to follow.

Basically, I will have different data for different people on different worksheets. On sheet 1 I want to be able to choose which person's data is displayed.

Is anyone able to help me with how I would achieve this?

Cheers