I've created a dynamic column chart, but the range always contains the first blank cell, and so there's a blank column at the end of the chart.
Is there anyway i can get the range to go stop at the last cell with a value in it?
The data is set up in rows, with each column as a date.
In the chart the date is on the x axis and the data categorie values on the y axis.
I defined names as:
XDate = OFFSET(daily!$D$2,0,1,1,COUNTA(daily!$2:$2))
YBuildTarget = OFFSET(daily!$D$5,0,1,1,COUNTA(daily!$5:$5))
and for the series formula entered:
=SERIES(daily!$D$5, 'main daily.xls!'XDate,'main daily.xls!YBuildTarget, 1)
I've found out that the problem was that for some reason, when the x-axis is on time-scale, there's no blank space at the end, but if it's on category there is.
I need it on category as i only want the dates in that i've got data for - is there a way of getting rid of that end blank when x-axis is on category?
I've used those formulas.
It leaves a blank in the chart if the x axis is category, and doesn't if its time scale. But i need category so that it only displays x values that there's data for.