Create chart where user select part of data

[Endorphin]

Hi All,

I am trying to find the best way to get the attached data into a chart format where a user can select a ID and view historical voltage data for that ID in the form of 1 line chart showing each aspect, so 3 lines Red, Yellow, Green.
The full data file is about 1100 Rows, by about 31 Columns, it will get to this over time as more voltages are taken.

I have tried to put the data in a pivot chart but keep having real problems getting the data in the right format.

I have done this in the past but really cannot get my head around it today..

Any help would be appreciated.

Neil

[Andy Pope]

One way would be to create a table based on selected ID.
The ID is selected in K1 using Data validation.

One problem with this approach is the formula will plot zeros for empty cells.

[Endorphin]

Thanks Andy, Will give it a go.

[Endorphin]

Hi Andy,

You did exactly what i was after, but as you said, the Blanks as Zeros is a problem.

Neil

[Andy Pope]

This variation handles empty cells.

[Endorphin]

Perfect !

Exactly what I was after, Many Thanks

Neil