#1
|
|||
|
|||
Help creating a chart and/or a pivot
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 |
#2
|
|||
|
|||
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). |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
creating a marco that extract information from pivot table | olybobo | Excel Programming | 2 | 05-18-2016 06:10 AM |
Create PIVOT chart using few rows in pivot table | Santhosh_84 | Excel | 1 | 08-31-2015 06:22 AM |
Creating a new tab with different kind of chart | aaslezak | Visio | 1 | 08-25-2015 07:08 PM |
Creating an Organization Chart Template | glosos | PowerPoint | 0 | 07-25-2013 01:25 PM |
Creating Chart using VB textbox value | shyler82 | Word VBA | 0 | 03-12-2010 06:56 PM |