dynamic chart

5
Jan Feb Mar Num 1 2 3 Den 1 2 4 per 100% 100% 75% Tar 90% 90% 90% OFFSET($A$7,0,0,1,COUNTA($ 0 2 4 6 8 10 12

Upload: bilal-salameh

Post on 01-Oct-2015

212 views

Category:

Documents


0 download

DESCRIPTION

DC

TRANSCRIPT

Sheet1JanFebMarAprMayJunJulAugSepOctNovDecNum123232421021Den124345555051per100%100%75%67%75%40%80%40%20%ERROR:#N/A01Tar90%90%90%90%90%90%90%90%90%90%90%90%OFFSET(ExpandingChart!$J$10, 0, 0, COUNTA(ExpandingChart!$J:$J)-1, 1)OFFSET(ExpandingChart!$I$10, 0, 0, COUNTA(ExpandingChart!$I:$I)-1, 1)OFFSET($A$7,0,0,1,COUNTA($7:$7)-1)

Sheet2DateSales10/10/038210/12/035511/11/0352

salesOFFSET(ExpandingChart!$J$10, 0, 0, COUNTA(ExpandingChart!$J:$J)-1, 1)dateOFFSET(ExpandingChart!$I$10, 0, 0, COUNTA(ExpandingChart!$I:$I)-1, 1)

Sheet3