Timeseries chart - combining values of field to create multiple series

1

I have data that looks like this:

date store purchases returns
2014-12-29 Store A 6000 800
2015-01-05 Store A 26000 4000
2014-12-29 Store B 1300 600
2015-01-05 Store B 4900 2000

 

How do I create a timeseries chart which would create 4 lines? The X axis would be date, Y axis count, Line 1 = Store A Purchases, Line 2 = Store B Purchases, Line 3 = Store A Returns, Line 4 = Store B Returns.

Right now, all I am able to successfully get is 2 lines with Store A Purchases and Store B Purchases.

Thanks

d.b's picture
d.b
64
Joined: Dec 30 2014 - 6:59am
Last seen: 4 years 9 months ago

1 Answer:

0

Used multi axis charts

d.b's picture
d.b
64
Joined: Dec 30 2014 - 6:59am
Last seen: 4 years 9 months ago
Feedback