Charting occurrences over varying time periods

bex1210

New Member
Joined
Mar 5, 2018
Messages
2
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 (y) 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 (y) 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 (y) 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
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Welcome to the forum.

I can't really directly answer your question. But I can say that Pivot Table are ideal for this type of task. Excel's help (or any other kind of general text) is usually difficult to understand, so I rely on learning through videos...and you might too. Check out this and other related videos about Pivot Tables on youtube from the ExcelIsFun channel.

https://www.youtube.com/watch?v=e-yuYNgsHAk
 
Upvote 0
DRSteele:

Thanks for the link to the video. I see that it is the video of a college course on Pivot tables, so I assume it is thorough.

I was hoping that Excel had that capability built in somewhere that I missed, but I guess that was wishful thinking.


Harry
 
Upvote 0

Forum statistics

Threads
1,223,894
Messages
6,175,252
Members
452,623
Latest member
Techenthusiast

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top