Thread: values in a chart that shouldn't be there

Originally Posted by brassmonkey

Hi,

i have a strange problem :

I have two columns to put in a chart, one contains values entered manually (x axis)(no formulas inside) and the other one check if the content of the first is "", if yes its content is "" (y axis).

When I create a chart with these 2 columns (i have 4 lines of content) it works, the chart has the good values. But when i change the number of columns (from 4 to 200, but 5-200 are empty cells), i get a wrong chart as if the cells from 5 to 200 had a content (0 or something). So the chart shows values on the X axis from 0 to 200 but actually, there is only values for 1 to 4...

any idea ?

Do you mean that you want your chart Source Data to be variable depending on the number of columns used? -

if so, then you need, under trigger, to set

ActiveChart.SeriesCollection(1).Values = "=Sheet2!R1C1:R1C" & LastColUsed

(untested) or something similar.

Are you familiar with WorkSheet_Change etc?

---