Line Chart Multiple Series Based off Column

New Contributor

I want to make a line graph with multiple series. Can I make it so column D assigns the data to one series or the other based on if column B is 1 or 2? Obviously I could select individually but there will be more data later. 

 

Any help would be appreciated. Thanks!

 

matt-hironimus_0-1620331569728.png

 

1 Reply

@matt-hironimus 

No, each series should be based on a contiguous range of cells.