May 06 2021 01:06 PM
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!
May 06 2021 01:49 PM
No, each series should be based on a contiguous range of cells.