Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mark
 
Posts: n/a
Default > 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   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

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   Report Post  
mark
 
Posts: n/a
Default

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   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Plotting different length series in a chart Big Red Charts and Charting in Excel 2 May 5th 05 02:00 PM
Y-Bars for Columns in a series CajunDan Charts and Charting in Excel 2 March 13th 05 02:31 AM
How to add series with VBA? deko Charts and Charting in Excel 0 March 8th 05 02:05 AM
Dynamic series in Chart Jeff Charts and Charting in Excel 2 February 24th 05 11:54 AM
How do I force a series in a Bar-Line Chart to be a Bar? Excel Challenged Charts and Charting in Excel 1 December 6th 04 04:16 AM


All times are GMT +1. The time now is 08:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"