hi there,
i have a table of data consisting on monthly info. this data comes from multiple sources which include an IF formula, when it is false it puts on a blank space " ".
im using the offset function to name the dynamic ranges:
=offset(page!$A$2,1,0,COUNTA(page!$A:$A)-1,1) for labels
and
=offset(labels,0,1) for values
then i substitute the series with
=series(page!$A$2,page!labels,lage!values,1)
but it doesn't seem to work if the cell is blank but it is actually a formula, it takes a larger range and the chart doesn't look nice...
Hi roxrocks
The problem is that Counta() includes cells with empty strings in the count.
Try instead:
=OFFSET(Page!$A$3,0,0,ROWS(Page!$A$3:$A$100)-COUNTBLANK(Page!$A$3:$A$100),1)
Adjust the last row if you think the data can ever go beyond row 100.
Last edited by lecxe; 02-07-2008 at 12:27 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks