Results 1 to 4 of 4
  1. #1
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Fairly Simple Question

    Had a request to create a scatter graph. The data series is to plot the due dates of each task. The due date is the X axis, Task is the Y axis.

    Data Series is as follows:

    Task 1 - Due 3/19/2010
    Task 2 - Due 5/1/2010
    Task 3 - Due 7/15/2010
    Task 4 - Due 12/15/2010

    The graph should show Tasks 1 through 4 as individual items on the Y axis with a plotted point shown for the corresponding date on the X axis. Something similar to the look of the attached sheet.

    Sounds easy enough but I can't do it. I could create something similar using a pivot table but they want a graph. Can someone please steer me in the proper direction.
    Attached Files Attached Files
    Regards,

    Gary
    (It's been a while!)

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    This is as close as I can get with a scatter chart. A line chart (with axes reversed) would be easier! Or even a bar chat with no fill and data labels set to display X.
    Attached Files Attached Files
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by rory View Post
    This is as close as I can get with a scatter chart. A line chart (with axes reversed) would be easier! Or even a bar chat with no fill and data labels set to display X.

    Rory,
    Thanks. The example helped a lot. However, I do have one question.

    How did you get the starting date of the X Axis to lock to the date? Whenever I set the min and max values for the X axis the min always resets back to zero and shows on the graph as 1/0/1900. (I do not want it to do this!) Thanks.
    Regards,

    Gary
    (It's been a while!)

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    The dummy series (for the labels) are all plotted on a second X axis (formatted with no line or labels). I didn't adjust the primary X axis at all. Does that help?
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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