+ Reply to Thread
Results 1 to 5 of 5

Options to chart monthly events and compare to other months

  1. #1
    Registered User
    Join Date
    07-14-2016
    Location
    Edmonton Ab
    MS-Off Ver
    Office 2007
    Posts
    3

    Question Options to chart monthly events and compare to other months

    Hard to explain so please bear with me. I am a volunteer driver and would like to chart my trips and compare them month to month.
    My spreadsheet log sheet (Excel 2007) has the dates of my trips, some days there may be no trips, other days several. How, can I chart this.. and have multiple months on the chart as well.
    What I think I want.. is a chart that shows a point (representing a trip) located on a generic month time line. And multiple months identified by colour?

    Any suggestions on how I might accomplish this would be greatly appreciated.
    Thank you for your time.
    Ralph

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,914

    Re: Options to chart monthly events and compare to other months

    Could you attach a sample workbook showing the data you have?

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    BSB

  3. #3
    Registered User
    Join Date
    07-14-2016
    Location
    Edmonton Ab
    MS-Off Ver
    Office 2007
    Posts
    3

    Question Re: Options to chart monthly events and compare to other months

    As requested if it helps attached is one months data. My desire is to "somehow" be able to compare one months rides to others.
    A generic 31 day calendar along the bottom axis with rides shown as points corresponding to the date taken along the side axis ??
    Attached Files Attached Files

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,914

    Re: Options to chart monthly events and compare to other months

    Perhaps something like the attached?

    Note the numbers in red are made up rather than formula generated (like the Jun2016 ones are) because there was only one month work of data provided. But in theory you could adapt the formulas for June to refer to each month's page.

    If I've completely misunderstood then let me know.

    BSB
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-14-2016
    Location
    Edmonton Ab
    MS-Off Ver
    Office 2007
    Posts
    3

    Re: Options to chart monthly events and compare to other months

    Wow.. your time on this is very much appreciated. This gives me a good start, again thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 05-13-2016, 10:33 AM
  2. Replies: 9
    Last Post: 06-10-2015, 09:40 AM
  3. Trying to only compare one bar in a bar chart that has multiple months
    By BrookieOU in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-10-2015, 07:38 AM
  4. Automation of Monthly Chart worngly populated if data less than 4 Months (Jan-Mar)
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-29-2014, 10:00 AM
  5. compare monthly figures in one chart
    By Davycc in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-20-2014, 02:08 PM
  6. Allocate monthly pay across months.
    By faithnfaith in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-10-2013, 12:47 AM
  7. Help needed using Userform to add events to monthly calendars
    By lax2734 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-06-2013, 04:30 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1