Chart Series drop down option

I have a chart which is designed using series data.

The X axis has 31 days, representing 31 days of the month, the series data is then links to various managers giving a percantage. With 9 managers it can look a bit busy.

What would be nice is to have a drop down box or a list box to allow me/my manager to select which series (or multiple series is poss) which we want.

I'm guessing vba is needed, my vba is very limited and i usually use the macro recorder to see how the vba is written to impliment it, in this case I wouldnt know where to start.

Any help?

Hi,
please post in the correct forum.It gives you a better chance on a quick answer I will move this one to the Charts forum for you

Thanks Andy I have read many of your helpful tutorials before!

What I was hoping what to have the drop box box/list box within the Chart sheet, not a chart as a item on a sheet

Depending on your source data, a Pivot Chart should do the trick

Hi Guys,

I read that tutorial, but am still confused.

Espically about the - =OFFSET(A5,0,$H$1)

I've created the list box, I have the right lists in the list box, I just need to somehow link it so when the names are clikc the chart changes

Here we go

I didnt think it was worth while making a new post as my question is on theback of this.

I have another excel sheet that I want to create a list box. I have used the above code, but chnaged the range to the correct one

Please Login or Register  to view this content.

It wouldn't work so I included an error catch and the error i keep getting is:

method 'range' of object '_worksheet' failed

Am i doing something drastically wrong?

EDIT:

I can get the list box to work if its on the same sheet as the data tables....it just seems if I add it to the chart sheet...

Andy,

Still getting the same error with the below code.

Please Login or Register  to view this content.

Please find the attached sheet.