+ Reply to Thread
Results 1 to 2 of 2

Plot points with same x-value in same series?

  1. #1
    smKing
    Guest

    Plot points with same x-value in same series?

    My chart has four categories on the x-axis: Red, Blue, Green Yellow.
    The y-axis is prices.

    I used a line-chart to show the average price for each color. Now I want to
    plot points on the same chart showing the actual prices for actual items, and
    that way can tell at a glance how near the points tend to be to the "average
    line".

    So:

    Item Color Price
    Bob Red 2.20
    Bill Red 4.50
    Joe Blue 2.20
    Dan Blue 2.20
    Ann Green 3.20
    Lynn Yellow 4.50

    As you can see, several items may have the same color, and thus the same
    x-value.
    The number of items is much more than shown here--there are hundreds. If
    only points in different series can share the same x-value, I will have to
    use hundreds of series! And then the legend will be huge!

    Is there a chart type that will work for me?

  2. #2
    Barb Reinhardt
    Guest

    Re: Plot points with same x-value in same series?

    If it were me, I'd define

    1=Red
    2=Blue
    3=Green
    4=Yellow

    using a helper series and plot a scatter chart using the data. I'd then
    use Rob Bovey's XY Chart labeler to put in the correct color labels.

    http://www.appspro.com/Utilities/ChartLabeler.htm

    You'll need to plot a dummy series for the labels at approx.

    X Y
    1 0
    2 0
    3 0
    4 0

    in order to use the Chart Labeler.
    "smKing" <[email protected]> wrote in message
    news:[email protected]...
    > My chart has four categories on the x-axis: Red, Blue, Green Yellow.
    > The y-axis is prices.
    >
    > I used a line-chart to show the average price for each color. Now I want

    to
    > plot points on the same chart showing the actual prices for actual items,

    and
    > that way can tell at a glance how near the points tend to be to the

    "average
    > line".
    >
    > So:
    >
    > Item Color Price
    > Bob Red 2.20
    > Bill Red 4.50
    > Joe Blue 2.20
    > Dan Blue 2.20
    > Ann Green 3.20
    > Lynn Yellow 4.50
    >
    > As you can see, several items may have the same color, and thus the same
    > x-value.
    > The number of items is much more than shown here--there are hundreds. If
    > only points in different series can share the same x-value, I will have to
    > use hundreds of series! And then the legend will be huge!
    >
    > Is there a chart type that will work for me?




+ Reply to Thread

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