Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
Adding "fixed" data to variable length data | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |