Scatter Point chart labels are missing

[Chad Cameron]

Hi All,

My subject doesn't quite cover it all, here is a rundown.

I have a fairly large spreadsheet. +/- 100 tabs. 1 tab is my data, then 4
tabs of graphs, repeated somewhere around 20-25 times. One of my graphs is
a scatter point chart. For the longest time the chart worked great. Then
all of a sudden it started to no longer label my points. I think it was
because my chart data range extended beyond my data. (not sure). Now I have
reached the end of my data range it no longer works. I have extended my
data range, but the labels don't appear.

I downloaded an addin from an MVP (sorry, I don't remember your name), and
then looked at the vba and used a chunk of it so that I can automate it.
Which worked with problems.

It appears, if we enter is some wrong data into the datasheet, and then
delete the row, it screws everything up. I have to delete the data in the
chart and then redo the data range for it to work. (my code and the addin).

I don't know why this happens or what to do for a work around. Basically I
run my code until it crashes and then I have to do the rest manually.

TIA
Chad
Excel 2000

 

[Karthik Dayalan]

use the below link and download the software "Download the XY Chart Labeler 7.0.12" and folow the instructions given in "Getting Started" "This instructions document".

It's free and even i had the same problem and it got solved.

Regards,
Karthik.D




Chad Cameron wrote:

Scatter Point chart labels are missing
15-Nov-09

Hi All

My subject does not quite cover it all, here is a rundown

I have a fairly large spreadsheet. +/- 100 tabs. 1 tab is my data, then
tabs of graphs, repeated somewhere around 20-25 times. One of my graphs i
a scatter point chart. For the longest time the chart worked great. The
all of a sudden it started to no longer label my points. I think it wa
because my chart data range extended beyond my data. (not sure). Now I hav
reached the end of my data range it no longer works. I have extended m
data range, but the labels do not appear

I downloaded an addin from an MVP (sorry, I do not remember your name), an
then looked at the vba and used a chunk of it so that I can automate it
Which worked with problems

It appears, if we enter is some wrong data into the datasheet, and the
delete the row, it screws everything up. I have to delete the data in th
chart and then redo the data range for it to work. (my code and the addin)

I do not know why this happens or what to do for a work around. Basically
run my code until it crashes and then I have to do the rest manually

TI
Cha
Excel 2000

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
C# : row-clickable GridView and get and set gridview rows using JavaScript
http://www.eggheadcafe.com/tutorial...9465-c45307bae45b/c--rowclickable-gridvi.aspx