Conditional Chart Data

**tortuga08** · 03-02-2020, 01:05 PM

Hello. I'm sure this is an easy problem but I can't figure this one out and can't find any examples of this online.

I have data that looks like this:
Date Device Value
3/2/2020 a 10
3/2/2020 b 80
3/3/2020 a 9
3/3/2020 b 85
3/4/2020 a 7
3/4/2020 b 83
3/5/2020 a 10
3/5/2020 b 80
3/6/2020 a 5
3/6/2020 b 90

Device A Temp
Device B Humidity

I would like to create a dynamic table that can display these values over time and as I get new posts by these devices. Right now I'm struggling with how to separate the data into two separate lines on a chart. The values for both devices are printing in the same column. I would like to plot device a and device b as separate lines on the same chart. Is this possible?

Thanks

**MrShorty** · 03-02-2020, 02:24 PM

I would probably use a technique like this: https://peltiertech.com/conditional-...-excel-charts/

Assuming your data is in column A:C:
1) At the top of column D, enter "a", at the top of column E, enter "b".
2) In D2, enter =IF(D$1=$B2,$C2,NA()) note the mix of relative and absolute references for easy copying.
3) Copy D2 and paste/fill into E2 and down as far as needed.
4) Build your chart based on columns A, D, and E.

Will that work for you?