Home |
Search |
Today's Posts |
#1
|
|||
|
|||
> 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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting different length series in a chart | Charts and Charting in Excel | |||
Y-Bars for Columns in a series | Charts and Charting in Excel | |||
How to add series with VBA? | Charts and Charting in Excel | |||
Dynamic series in Chart | Charts and Charting in Excel | |||
How do I force a series in a Bar-Line Chart to be a Bar? | Charts and Charting in Excel |