Hi! My name is Julie, and I need help visualizing some YouTube channel analytics data over time.
Attached is the spreadsheet I’m working on as well as quick mock-up in Paint of what I’d like the graph to look like.
On the spreadsheet, column B represents each individual series I would like. As in, each cell in column B would be its own column of data on the chart, with two lines, one representing the trend of subscription ranking and one representing the trend of view ranking. One line will be columns C-D, and another separate line will be columns E-F.
As a note, I’ve made the rankings negative so that a jump to a better ranking is indicated by a line with a positive slope in the chart.
I’m hoping this is possible to do with excel, but so far all my efforts have been thwarted. I’m willing to use an app or other software for this, provided it doesn’t require programming skills.