Hey there. I have data for every day of 2016 that I'd love to get into a chart.


Effectively it's 24 columns with alternating day, data, day data.
(I recorded step counts for the entire year)

Anyone help me get some data visualization going?
I can get a simple XY month/total but I'd like to be able to drill down into the individual days.

Windows 10
Office 2013

Without seeing your actual (or at least sample) data, hard to tell; although, it sounds like with your data spread out among columns, this is making things difficult.

Can all the data be in a long column. That is 1/1/16 down to 12/31/16 in one column and the data in the second column?

Once you do this you can easily create pivot charts and group by data (month and years).