How to merge two line charts?

[Anonymous]

Hello! I have two tables. The first table hast two columns: timestamp and power being consumed over time. The second table has two columns too: timestamp and state of the device (consuming power =3, not consuming power =2). This means both tables relate to the same device. I want to create a graph with two line charts over time. But when I add time and value (twice) to the graph, one of them just stays at 0 the whole time. Any help?

[Anonymous · Accepted solution]

Hi i tested it for you and believe you do everything right.

My quess is either there is no relationship between the 2 tables. In that case add the 2nd timestamp to Axis aswell. OR the values of Power consumption overtime are so high it looks like the 2's and 3's are all the same. 

I used these tables to test:

Timestamp	Power consumed
1	1
2	3
3	4
4	2
5	3
6	1
7	4
8	5
9	7
10	1

 and

Timestamp	State of device
1	2
2	3
3	2
4	2
5	3
6	3
7	2
8	3
9	2
10	3

Result

if this is incorrect, please share some sample data i can correct my answer with. 

Goodluck! 🙂

[Anonymous]

Hi! First of all, thanks a lot for your help! You are right, the problem is that the 3 and 2 look the same because the power values are so high. Do you know how I can add a second Y-Axis so that the 3 and the 2 are visible? Thanks!

[Anonymous]

you could use a bar + line chart for that.