Results 1 to 3 of 3

Need x-axis to show individual lots grouped by month

Threaded View

  1. #1
    Registered User
    Join Date
    08-19-2010
    Location
    Anderson, SC
    MS-Off Ver
    Excel 2007
    Posts
    2

    Need x-axis to show individual lots grouped by month

    Hi all,

    I'm looking for some assistance creating a column chart that to show 2 categories of data and group one of those categories by month.

    As it stands, this is what I have:
    y - Pts per /100 yards
    x - Lot #

    I need to keep the lot numbers in order but also group them by month. For example:

    Lots 715-729 were ran during the month of February.
    Lots 730-742 were ran during the month of March.

    I'm trying to place something underneath the x-axis labels (lot numbers) that will show the months they were ran, like this:

    715 716 717 718
    |---------FEB-------------|

    Everything I've tried just gives me one bar of every lot for each month. I need a bar for every lot, while still separating them by month.

    I've been working on this for three hours straight, so forgive me if this post is hard to follow. I could really use a nudge in the right direction if anyone cares to help. The file is attached. Thanks.

    Chad
    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