Line chart for multiple data

[SAN04]

Hello,

In attached sheet there is database.

From the data base i have prepared chart for selective category and type. Mainly for S.no "1" and "A0".

The same chart is required to be prepared for "A1" to "A5"and "B1" to "B5".

Please help for some automatic way. (I dont want to copy chart and drag the selection)

Thanks in advance.

 

[SAN04]

Hello,

In attached sheet there is database.

From the data base i have prepared chart for selective category and type. Mainly for S.no "1" and "A0".

The same chart is required to be prepared for "A1" to "A5"and "B1" to "B5".

Please help for some automatic way. (I dont want to copy chart and drag the selection)

Thanks in advance.

Attachment please

 

[vletm]

SAN04
You have there two same charts.
What kind of charts there should be?

 

[SAN04]

Similar charts. i require for A2 to A5 and B1 to B5 and for selected rows as shown in two graphs.

Thanks

 

[vletm]

SAN04
For my eyes those same charts ... okay - - then those are same time similar.
If You would like to see two times same/similar chart then ... look twice.
My sample file has one chart.
Usage: select any cell from A-column to see that 'parts' (15rows) chart to get those some automatic way (as You've written).

 

[SAN04]

Thanks Vletm!!!

However, i need all charts to be in another sheet together as Dashboard. This from serial no "1" to s.no "C". One chart for each below with similar series. Also to be displayed in one sheet.

1
A0
A1
A2
A3
A4
A5
B1
B2
B3
B4
B5
C

 

[vletm]

SAN04
I need answers.
Could You reread Your original writing?

 

[SAN04]

Yes