+ Reply to Thread
Results 1 to 4 of 4

> 12 series displayed, or better way?

  1. #1
    mark
    Guest

    > 12 series displayed, or better way?

    a user has 11 curves to dispay.

    in addition, there is a series of X,Y pairs that he would
    also like to display.

    when the (x,y) pairs are displayed (they are actually
    discrete points), the first one shows fine, but any point
    added after the first, does not visibly appear on the
    chart.

    I tried deleting one of the 11 curves... then a second
    (x,y) point would display.

    It appears that the chart was only able to handle 12 sets
    of data. The reason that I tried to do it with a new
    series for each (x,y) pair is that the info displayed when
    the cursor hovers over the data point is much more
    relevant. It displays the specific employee's name who
    that data point represents... not just the "series
    Population" and then the x,y coordinates.

    I don't know how for sure how many persons (the x,y
    scatter points)will be wanted to be displayed on the
    chart, but am told it will be roughly 100.

    Ideas or suggestions?

    Thank you.

  2. #2
    Jerry W. Lewis
    Guest

    Re: > 12 series displayed, or better way?

    The number of series is not the issue. Without more information, we
    cannot guess at what is the issue.

    I have a template that plots 58 data series, and all show. My
    recollection is that more would plot, but the legend is limited to 30
    entries (chart location "As New Sheet") unless you reduce the font size.

    Note that Excel does not skitter data points for visibility, so if
    points or curves are superimposed, it is possible that only the highest
    series will be visible even though all are present.

    Jerry

    mark wrote:

    > a user has 11 curves to dispay.
    >
    > in addition, there is a series of X,Y pairs that he would
    > also like to display.
    >
    > when the (x,y) pairs are displayed (they are actually
    > discrete points), the first one shows fine, but any point
    > added after the first, does not visibly appear on the
    > chart.
    >
    > I tried deleting one of the 11 curves... then a second
    > (x,y) point would display.
    >
    > It appears that the chart was only able to handle 12 sets
    > of data. The reason that I tried to do it with a new
    > series for each (x,y) pair is that the info displayed when
    > the cursor hovers over the data point is much more
    > relevant. It displays the specific employee's name who
    > that data point represents... not just the "series
    > Population" and then the x,y coordinates.
    >
    > I don't know how for sure how many persons (the x,y
    > scatter points)will be wanted to be displayed on the
    > chart, but am told it will be roughly 100.
    >
    > Ideas or suggestions?
    >
    > Thank you.



  3. #3
    mark
    Guest

    Re: > 12 series displayed, or better way?

    >Note that Excel does not skitter data points for
    visibility, so if points or curves are superimposed

    Nope, not that. Checked that.

    So, short of sending the file (which I know is usually
    taboo), I really don't have a way to describe it any more
    fully.

    Agreed, it must be something else.

  4. #4
    Jerry W. Lewis
    Guest

    Re: > 12 series displayed, or better way?

    Send it to jwLewis53ATcomcastDOTnet with the obvious substitutions for
    capital letters.

    Jerry

    mark wrote:

    >>Note that Excel does not skitter data points for
    >>

    > visibility, so if points or curves are superimposed
    >
    > Nope, not that. Checked that.
    >
    > So, short of sending the file (which I know is usually
    > taboo), I really don't have a way to describe it any more
    > fully.
    >
    > Agreed, it must be something else.



+ 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