• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Line chart for multiple data

SAN04

Member
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.
 

Attachments

  • Graph.xlsx
    52 KB · Views: 4
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
 

Attachments

  • Graph.xlsx
    52 KB · Views: 3
Similar charts. i require for A2 to A5 and B1 to B5 and for selected rows as shown in two graphs.

Thanks
 
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).
 

Attachments

  • Graph2.xlsb
    45.2 KB · Views: 7
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
 
Back
Top