News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • graph enumerated values

    Posted on WSDan.. Comment on the AskWoody Lounge
    Viewing 1 reply thread
    • Author
      • #351453 Reply
        AskWoody Lounger

        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.

      • #508523 Reply
        AskWoody Lounger


        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.


        • #508696 Reply
          AskWoody Lounger

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

          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.

    Viewing 1 reply thread

    Please follow the -Lounge Rules- no personal attacks, no swearing, and politics/religion are relegated to the Rants forum.

    Reply To: graph enumerated values

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.