Scatter Chart Lost Labels

[Chad]

Column A = Point ID
Column B = Northing
Column C = Easting

My datasheet has about 200 entries in it.

My chart shows all these entries, but the last 10 or so points on the chart
no longer have the Point ID beside them. All my ranges appear to valid.

Any ideas?
Chad

 

[Del Cotter]

Column A = Point ID
Column B = Northing
Column C = Easting

My datasheet has about 200 entries in it.

My chart shows all these entries, but the last 10 or so points on the chart
no longer have the Point ID beside them. All my ranges appear to valid.

If you're using a macro or add-in to add the point IDs as labels, then
you will have to run the macro every time you change the ranges. It
doesn't adapt to changes in the range, as for instance if you added ten
new points.

 

[Andy Pope]

Hi,

Have you extended the data series recently?
I assuming you either manually or more likely via an addin connected
each data label to a cell. If you then extend the data series you will
need to apply the link to the new data labels.

Cheers
Andy

 

[ShaneDevenshire]

Can you show us a sample of the data - for example are the Point ID's
numbers, dates, text?

What version of Excel are you using?

What kind of chart are you using - line, scatter, column....?

Notes: Excel supports substantially more data points than you are trying to
display.

Here are the limits for 2003:

Feature Maximum limit
Charts linked to a worksheet Limited by available memory
Worksheets referred to by a chart 255
Data series (data series: Related data points that are plotted in a chart.
Each data series in a chart has a unique color or pattern and is represented
in the chart legend. You can plot one or more data series in a chart. Pie
charts have only one data series.) in one chart 255
Data points (data points: Individual values that are plotted in a chart.
Related data points make up a data series. Data points are represented by
bars, columns, lines, slices, dots, and other shapes. These shapes are called
data markers.) in a data series for 2-D charts 32,000
Data points in a data series for 3-D charts 4,000
Data points for all data series in one chart 256,000
Line styles 8
Line weights 4
Area patterns (screen display) 18
Total area pattern and color combinations (color display) 56,448
Pattern and color combinations (color printer) 56,448 (the actual number
depends on your printer and its software)

 

[Chad]

Thanks for the replies Del, Andy, Shane;

It's Excel 2000 XY Scatter Chart.

I am not using macros or addins in this section. I didn't create the
charts, and I am not good at charts. It makes sense that I have to extend
my data series. I know I haven't hit the limits of Excel.

In my sourse data properties on the series tab I have the following

1 item listed in the Series Section. it says STATION LOCATION
Name: ="STATION LOCATION"
X Values: is a range of my Eastings Column
Y Values: is a range of my Northing Column.

I cannot find any definition of STATION LOCATION

One other item I am noticing. I guess if I delete a row of data, and then
look at my chart, I see a Label with #REF! how do i fix those as well.

Thanks again
Chad

 

[Tushar Mehta (Microsoft MVP Excel 2000-2008)]

The only way to use a column other than the x-values or the y-values
as the data label is through a "non-default" mechanism. The typical
approach is through code (or an add-in) but it might also have been
set up by hand (for an example see Data Labels --
http://www.tushar-mehta.com/excel/newsgroups/data_labels/index.html)

The #REF! error is consistent with the use of a separate column for
the data label.

The only way to keep the data labels up to date is to reset them. You
can do that by hand or through an add-in. See the link above.

 

[Chad]

Thanks for all your help,

but I am still stumped on this one.

I couldn't find any way to reset my chart, data, labels, unless you mean
creating a new one.

Everywhere I look, I see this label called STATION LOCATION. I am assuming
it is pointing to the range of labels for my chart, and I am pretty sure
that my labels have exceeded that range, but I cannot find the definition of
that label. Is there way way to find it?
It is not listed in the "Insert->Name->Define" list

Thanks
Chad

Sorry for the delay

"Tushar Mehta (Microsoft MVP Excel 2000-2008)"