Collate Rows in Stacked Bar Chart?

Occasional Visitor

I want to produce a line chart or stacked column chart from the following Excel table:

 

DATENETWORKFOLLOWERS

1/1/2015

Facebook7
1/1/2015Instagram12
1/1/2015Twitter24
1/2/2015Facebook7
1/2/2015Instagram13
1/2/2015Twitter26
1/3/2015Facebook8
1/3/2015Instagram14
1/3/2015Twitter

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.

1 Reply

@ddelbridge How about a pivot table with some pivot charts. Shouldn't be a problem to use this with 15000 rows. Example attached.

Screenshot 2022-09-14 at 06.06.59.png