Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-17-2017, 02:28 PM
jerrysmith jerrysmith is offline Help creating a chart and/or a pivot Windows 10 Help creating a chart and/or a pivot Office 2013
Novice
Help creating a chart and/or a pivot
 
Join Date: Jan 2017
Posts: 1
jerrysmith is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 01-17-2017, 04:38 PM
jeffreybrown jeffreybrown is offline Help creating a chart and/or a pivot Windows Vista Help creating a chart and/or a pivot Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

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).
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help creating a chart and/or a pivot creating a marco that extract information from pivot table olybobo Excel Programming 2 05-18-2016 06:10 AM
Help creating a chart and/or a pivot Create PIVOT chart using few rows in pivot table Santhosh_84 Excel 1 08-31-2015 06:22 AM
Help creating a chart and/or a pivot 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft