Results 1 to 3 of 3

charts and dates and groups of data

Threaded View

  1. #1
    Registered User
    Join Date
    11-24-2009
    Location
    Vietnam
    MS-Off Ver
    Excel 2003
    Posts
    18

    charts and dates and groups of data

    Hi guys - what a great forum you've got going on here! Have tried to find an answer to my question in the forum but can't quite get what I need.

    I would like to graph some data. I have only 2 columns of data. Column 1 is just dates, and column 2 is the word yes, or no.

    I would like to make a Chart of the amount of 'yes's or 'no's that occurred on a month by month or year by year basis. Date would be on the x axis. One of the tricky things is getting the date data to appear in the correct location once they are grouped. For example, if I was trying to group by month, and there were 3 consecutive months where I had no data, I need a 3 month gap to appear in the chart.

    Would love to know how to do this! Example data attached.

    John
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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