Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Complex Date chart question

I have a chart of data (2036 rows) that includes a date in each entry/row.

Some of the dates occur once, some of them occur several times.

I would like to create a chart that shows time (3 1/2 year period) along the
X-axis and the numbers of times each date occurs on the Y-axis (between 1 and
20).

How do I do this??? Each time I try I just get a jumbled mess. I think a
line or scatter graph would work best.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 235
Default Complex Date chart question

One option would be to create a pivot table on your chart source. Your row
field would be the dates and your data field would be a count of the dates.

Once the pivot table is created, you could create a bar chart with dates on
the x-axis and the count of the dates as your first series (bars). You can
also create a pivot chart which does the same thing. Just click somewhere
within your pivot table and hit the chart wizard icon.

--
John Mansfield
cellmatrix.net


"tiggers" wrote:

I have a chart of data (2036 rows) that includes a date in each entry/row.

Some of the dates occur once, some of them occur several times.

I would like to create a chart that shows time (3 1/2 year period) along the
X-axis and the numbers of times each date occurs on the Y-axis (between 1 and
20).

How do I do this??? Each time I try I just get a jumbled mess. I think a
line or scatter graph would work best.

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Complex Date chart question


Yep that worked a treat. I haven't used a pivot table before so it's a bit
of a learning curve. I appreciate you quick and useful reponse.

Thanks again!


"John Mansfield" wrote:

One option would be to create a pivot table on your chart source. Your row
field would be the dates and your data field would be a count of the dates.

Once the pivot table is created, you could create a bar chart with dates on
the x-axis and the count of the dates as your first series (bars). You can
also create a pivot chart which does the same thing. Just click somewhere
within your pivot table and hit the chart wizard icon.

--
John Mansfield
cellmatrix.net


"tiggers" wrote:

I have a chart of data (2036 rows) that includes a date in each entry/row.

Some of the dates occur once, some of them occur several times.

I would like to create a chart that shows time (3 1/2 year period) along the
X-axis and the numbers of times each date occurs on the Y-axis (between 1 and
20).

How do I do this??? Each time I try I just get a jumbled mess. I think a
line or scatter graph would work best.

Reply
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
another complex =IF question gimp New Users to Excel 8 June 27th 06 12:37 AM
Complex Sort Question Chas Excel Worksheet Functions 2 March 16th 06 03:14 AM
Complex query question Stacy Excel Worksheet Functions 0 June 30th 05 09:50 PM
complex count question JBoulton Excel Worksheet Functions 13 March 24th 05 03:57 AM
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question Barb Reinhardt Charts and Charting in Excel 3 December 8th 04 02:48 AM


All times are GMT +1. The time now is 01:52 AM.

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

About Us

"It's about Microsoft Excel"