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 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 do not appear.
I downloaded an addin from an MVP (sorry, I do not 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 do not 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
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/tutorials...le-gridvi.aspx