Prev: Graphing calender chart with combined relative amounts for each date
Next: Leableing of Scatter Plots
From: "Chad Cameron" NOTchad483 on 15 Nov 2009 23:36
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

 | 
Pages: 1
Prev: Graphing calender chart with combined relative amounts for each date
Next: Leableing of Scatter Plots