OFFSET Charts - moving data length
I have a set of data in col A [Name] and the data in col C [Cnt] which I have
a bar chart - fine, however col A is currently 10 rows but could grow to 20 rows or more. If I use the formual =FLUP_Business_Unit!$A$1:$A$20,FLUP_Business_Unit! $C$1:$C$20 then while the graph looks fine the Legend shows all the Rows that are blank. I have tried this but it doesn't seem to work. =OFFSET(FLUP_Business_Unit!$A$1,0,0,COUNTA(FLUP_Bu siness_Unit!$A:$A),1),OFFSET(FLUP_Business_Unit!$C $1,0,0,COUNTA(FLUP_Business_Unit!$A:$A),1) When I paste into the Data Range it does't seem to save it - Any ideas? Since it doesn't save I don't know if it is actually correct. |
All times are GMT +1. The time now is 09:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com