View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.charting
Chad[_3_] Chad[_3_] is offline
external usenet poster
 
Posts: 32
Default Scatter Chart Lost Labels

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)"
<ng_poster@tushar-underscore-mehta-dot-cee-oh-em wrote in message
...
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/ne...els/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.

On Sat, 7 Jun 2008 14:37:05 -0700, "Chad" wrote:

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