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.

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.

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.