Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Dec 2000
    Location
    Huntsville AL usa
    Posts
    35
    Thanks
    1
    Thanked 0 Times in 0 Posts

    graph enumerated values

    Can anyone help me graph enumerated values vs dates?

    I have data that contains a date and an emumerated value.
    Typical data looks like this:
    10-21-00 Green;
    10-22-00 Yellow;
    10-23-00 Red;
    10-24-00 Yellow;
    10-24-00 Green;
    10-25-00 Green.
    Think of this as the air quality level [Green, Yellow, Red] by day. The enumerated data is the air quality level.

    I would like the dates to appear across the bottom and the enumerated values [Green, Yellow, Red] to appear on the vertical y-axis. Above each date would be bullets indicating the enumerated values for that day.

    I defined the enumerated values with indexes of 1, 2, 3 and names of "Green", "Yellow", and "Red".

    My graph needs to use the enumerated value index as the plot value but use the enumerated value name as the y-axis label.

    Any thoughts would be most welcomed.

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: graph enumerated values

    Dan,

    About the only way I can think of is to graph using the indexes, and not to show the Value Y axis. Then put in a Y axis title- say "Green". Select it with a right click, and use the alignment tab to rotate it. Then click on the text, and add blank lines, and the other data labels.

    Geoff
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  4. #3
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: graph enumerated values

    Expanding the solution of gwithfield, consider splitting your series into 3 series:

    -;Green;Yellow;Red
    10-21-00 1;-;-;
    10-22-00 -;2; ;
    10-23-00 -;-;3;
    10-24-00 -;2;-;
    10-24-00 1;-;-;
    10-25-00 1;-;-;

    Then use a XY-Scatter diagram to plot the 3 series. Set the format without interconnecting lines and set the color and eventually size of you markers to your liking.

    If you get the data from another program, the best solution would be to use VBA. Whether to automate the above split or to post-process each graph point of an unsplit series is easier/more suitable is to be determined.

Posting Permissions

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