I have Office 2007 running on Windows 7 Pro (64 bit) SP1.
Hopefully someone can help with how to create a chart for a spreadsheet I am setting up. The spreadsheet has only two columns: Dates in Column A, and Events (1, 2, 3, etc.) on that date in Column B. My dates run from the year 2012 thru today.
But I don't have events that occur every day. For example, in 2012, events only occurred on 12 days. In 2013, on 46 days, etc. It is easy to set up a column chart with Days on the Horizontal (x) axis, and events on that day on the Vertical axis. But charting 5+ years of data, on a daily basis, is not easy to determine longer term trends. I can change the units on the (x) axis to months, or years, but that just forces the daily events closer together.
So what I want to do is have a spreadsheet which, went I vary the units on the (x) axis, will SUM all the daily units for that period. For example, if I choose monthly, and in January 2013 there were 4 events, I want the chart to display 4 on the axis column for January 2013, rather than 4 columns for January displaying 1 each. And if I choose quarterly, and there were 18 events in January through March, I want the chart to display 18 on the axis, rather than 18 columns displaying 1 each.
Is that doable in Excel 2007? If so, where can I find detailed information on how to set it up? I though perhaps that could be done with a Pivot Table, but the Excel Help was so vague that I could not figure out how to proceed.
Any help would be greatly appreciated,
Harry
Hopefully someone can help with how to create a chart for a spreadsheet I am setting up. The spreadsheet has only two columns: Dates in Column A, and Events (1, 2, 3, etc.) on that date in Column B. My dates run from the year 2012 thru today.
But I don't have events that occur every day. For example, in 2012, events only occurred on 12 days. In 2013, on 46 days, etc. It is easy to set up a column chart with Days on the Horizontal (x) axis, and events on that day on the Vertical axis. But charting 5+ years of data, on a daily basis, is not easy to determine longer term trends. I can change the units on the (x) axis to months, or years, but that just forces the daily events closer together.
So what I want to do is have a spreadsheet which, went I vary the units on the (x) axis, will SUM all the daily units for that period. For example, if I choose monthly, and in January 2013 there were 4 events, I want the chart to display 4 on the axis column for January 2013, rather than 4 columns for January displaying 1 each. And if I choose quarterly, and there were 18 events in January through March, I want the chart to display 18 on the axis, rather than 18 columns displaying 1 each.
Is that doable in Excel 2007? If so, where can I find detailed information on how to set it up? I though perhaps that could be done with a Pivot Table, but the Excel Help was so vague that I could not figure out how to proceed.
Any help would be greatly appreciated,
Harry