Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-05-2019, 02:31 PM
vthomeschoolmom vthomeschoolmom is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Feb 2012
Posts: 16
vthomeschoolmom is on a distinguished road
Default really simple graph question

I have a table. There is a column for an item title and a column for its creation date. I want a graph that shows me the number of items created by week.



How do I do this, please?
Reply With Quote
  #2  
Old 02-06-2019, 12:15 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,294
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

First create a Pivot Table
https://www.contextures.com/CreatePivotTable.html
Then group dates by week
https://www.contextures.com/xlPivot07.html
Finally create a chart with this Pivot Table
https://www.contextures.com/excelpiv...ourcedata.html
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 02-06-2019, 06:05 AM
vthomeschoolmom vthomeschoolmom is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Feb 2012
Posts: 16
vthomeschoolmom is on a distinguished road
Default

Thank you!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple copy question wbendermd Excel Programming 2 11-15-2018 08:00 AM
How do I make a simple graph with a list of dates at the bottom? MRnightmuffin Excel 1 01-18-2018 06:48 PM
A simple math question markg2 Excel 6 03-01-2014 11:10 AM
Simple graph in excel izzy786 Excel 1 09-08-2012 08:04 AM
Simple Envelope Question.... cmcneill Word 0 08-17-2009 05:12 PM


All times are GMT -7. The time now is 05:49 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft