Scatter Point chart labels are missing

  • Thread starter Thread starter Chad Cameron
  • Start date Start date
C

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
 
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
 
Back
Top