Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
another complex =IF question | New Users to Excel | |||
Complex Sort Question | Excel Worksheet Functions | |||
Complex query question | Excel Worksheet Functions | |||
complex count question | Excel Worksheet Functions | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel |