+ Reply to Thread
Results 1 to 3 of 3

Create a column chart by month with three separate contributors?

  1. #1
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    583

    Create a column chart by month with three separate contributors?

    Hi again...

    I have the following info on a worksheet: (Note: I apologize for the poor format; I don't know if there is a special tag I should be using and my attempt at using spaces failed miserably.)

    Name Date Fossils
    Tom 19-Jan-16 1
    Tom 10-Feb-16 7
    Tom 24-Mar-16 4
    Tom 23-May-16 2
    Jim 15-Dec-15 1
    Jim 16-Feb-16 2
    Jim 17-Feb-16 2
    Jim 24-Feb-16 1
    Jim 8-Mar-16 3
    Jim 19-Mar-16 2
    Jim 6-May-16 5
    Jim 6-Jul-16 8
    Mary 3-Mar-16 2
    Mary 12-Apr-16 2
    Mary 26-Apr-16 3
    Mary 5-May-16 4

    What I want to do is to create a column chart that on the bottom (X-Axis) is divided up by month/year, along the left side (Y axis) is in units and has columns of separate color identifying the person clustered in their respective months. I know how to change grouping from serial date to month - though maybe this is where I am going wrong - I am using the date column or extracts from it as my X axis. Should I be specifying an X axis of Date by month type instead with a range for whatever date range would encapsulate the dates used? This still wouldn't solve the problem of not being able to specify the date values of the additional series...

    I am going crazy here; I must be either selecting the wrong kind of chart or am in the dark as to how to handle the data. I tried first creating a series with Tom's data, highlighting the dates and units and creating a column chart from that, but when I went to add a series, Jim's, and tried to highlight the dates and units, I was forced to only add one column's data - there was no way to pair the units to the date (month) found.

    Does anyone know of an example of how to do this? It should be quite simple and intuitive. I really hate the words "should be"...

    Thank-you.
    Last edited by brucemc777; 08-05-2016 at 07:56 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,720

    Re: Create a column chart by month with three separate contributors?

    I think you need an X-Y Scatter graph, then the X-axis can represent the dates more accurately.

    Hope this helps.

    Pete

  3. #3
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    583

    Re: Create a column chart by month with three separate contributors?

    Thank-you!

    After going through endless examples I find that if I set the data up in columns with the entire range of dates in the first, then the subsequent columns of each individual with their respective units under their names and in the row of the proper date Excel will properly graph the scenario. Just a complete PITA to "automatically" rearrange the data from the tables I have, for the simple names & fossils was an extreme simplification of the actual dataset!

+ 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. Create 12 month rolling chart
    By bberger1985 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-19-2013, 12:24 PM
  2. Replies: 0
    Last Post: 11-12-2012, 06:32 PM
  3. [SOLVED] Using Macro to separate a spreadsheet and create tabs for each month
    By ajang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2012, 01:42 AM
  4. average column based of month in separate column
    By Freddobonanza in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-11-2011, 07:22 PM
  5. Create separate pivot chart for each filter?
    By oo0tommyk0oo in forum Excel General
    Replies: 4
    Last Post: 02-16-2011, 07:16 PM
  6. Can't create chart on separate sheet
    By Tiernobyl in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 12-18-2009, 08:52 AM
  7. Create separate columns from one column
    By sratkins in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2009, 09:36 PM
  8. [SOLVED] Create separate chart for each row in excel
    By Peter Nagy in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-04-2005, 09:05 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