Dynamic Charting - A little bit of help needed! Link to previous thread by Andy

[a45ward]

Hi there,

I've been having trouble creating a dynamic chart - I have used the following link to help which was previously attended to by someone called Andy who was really helpful.

http://www.excelforum.com/excel-char...down-list.html

I've managed to create the dynamic chart and get one row of data selected eg. Product B for 1992 - I'd like to get the same product information on the chart for 1993 whereby the data is directly below that of 1992.

I think I'm pretty close to solving it but was wondering whether anyone could help and take a look! :P.

At the moment Product A 1992 is static and is displayed in all charts whilst I'd like to ensure that I always have the same product but with the 2 different years data displayed at the same time.

I hope that makes sense!

Alan

[Andy Pope]

Add another named range that if offset from the DATA named range

DATA2: =OFFSET(DATA,-1,0)

You can then set the series to reference the new named range. You will also need to create a new named range for the Series name of the new series.