> 12 series displayed, or better way?

M

mark

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.
 
J

Jerry W. Lewis

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
 
M

mark

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.
 
J

Jerry W. Lewis

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

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top