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!




1 Reply


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