LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default make chart from dates in a column

I cant seem to figure this out. I have a worksheet that has a column
of dates. I want to create a chart that shows the sum of all the items
broken out by month and year. How can I do this?

Example:

10/10/2007 16:04
10/17/2007 16:10
1/3/2008 10:32
1/5/2008 14:00
2/4/2008 11:00
2/4/2008 11:30
2/10/2008 15:00

I would like this output to create a chart from -
Oct 2007 = 2
Jan 2008 = 2
Feb 2008 = 3

TIA
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I make Column Chart use percent and show value lunarpc Charts and Charting in Excel 3 November 8th 07 07:14 PM
Column-Line Chart w/ Dates Neutron1871 Charts and Charting in Excel 4 September 26th 06 06:51 PM
Column chart - category axis - make to start with the second label Marko Pinteric Charts and Charting in Excel 3 April 10th 06 09:31 AM
How can I make a chart with column A on xaxis & column B on Yaxis Sreedevi Excel Discussion (Misc queries) 1 April 4th 06 08:30 PM
make a weekly payment chart with running dates christmas saving club Excel Discussion (Misc queries) 0 February 20th 06 07:40 PM


All times are GMT +1. The time now is 10:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"