I want the 2 graphs in "Graph" worksheet to change automatically when a row is inserted in "Data" worksheet . Every time i have to change the graph manually to contain the latest 20 days value. I want some offset or something which can be put in the range provided below to do the work.
Chart Data Range =Data!$A$1:$A$22,Data!$F$1:$F$2,Data!$L$1:$L$20
Legend entries (Series) -
Series Name
=Data!$F$1 ( this will remain constant everyday as this is a header field)
Series Values
=Data!$F$2:$F$22 ( this should contain last 20 days range, for example if a next row is inserted tomorrow then
it should automatically change to =Data!$F$3:$F$23)
Legend entries (Series) -
Series Name
=Data!$L$1 ( this will remain constant everyday as this is a header field)
Series Values
=Data!$L$2:$L$22 ( this should contain last 20 days range, for example if a next row is inserted tomorrow then
it should automatically change to =Data!$L$3:$L$23)
Horizontal (Category) axis series -
Axis Label Range
=Data!$A$2:$A$22 ( this should contain last 20 days range, for example if a next row is inserted tomorrow then
it should automatically change to =Data!$A$3:$A$23)
Sheet attached. Please help me as i am a newbie.
Devicess.xlsx
Bookmarks