I want to produce a line chart or stacked column chart from the following Excel table:
| DATE | NETWORK | FOLLOWERS |
1/1/2015 | Facebook | 7 |
| 1/1/2015 | Instagram | 12 |
| 1/1/2015 | Twitter | 24 |
| 1/2/2015 | Facebook | 7 |
| 1/2/2015 | Instagram | 13 |
| 1/2/2015 | Twitter | 26 |
| 1/3/2015 | Facebook | 8 |
| 1/3/2015 | Instagram | 14 |
| 1/3/2015 | Twitter | 32 |
Three dates. Three Networks. Daily follower counts for each.
How do I produce a chart with the three unique DATE values (1/1/2015, 1/2/2015, and 1/3/2015) on the X axis and FOLLOWERS on the Y axis, with lines plotted for each NETWORK (Facebook, Instagram, and Twitter)? Or, better yet, I'd like to combine the NETWORK values into a stacked column chart to indicate total FOLLOWERS on each DATE.
I've played with this for a couple hours now and can't seem to figure it out - not without a gross reorganization of the data (e.g., one date per row and separate columns for each network). Unfortunately, that's not a good long-term solution because the data (currently 15,000 rows) is imported regularly from a third party. If there's no other way, I'll need to automate this reorganization somehow.
Any ideas?
Thank you for looking.
