K khushboo New Member Apr 17, 2013 #1 Hi! I want to keep columns fixed for the chart range. I want to show only 15 days data in my chart and when ever I insert a new column for the current date my last date in the chart should be removed n data for new date should be presented. Please help.
Hi! I want to keep columns fixed for the chart range. I want to show only 15 days data in my chart and when ever I insert a new column for the current date my last date in the chart should be removed n data for new date should be presented. Please help.
N nazmul_muneer Member Apr 17, 2013 #2 Dear Khushboo, Welcome to Chandoo's forum. You should make a dynamic chart. Use OFFSET() function and control your chart by two variable, i.e Start date and End date. Regards, Muneer
Dear Khushboo, Welcome to Chandoo's forum. You should make a dynamic chart. Use OFFSET() function and control your chart by two variable, i.e Start date and End date. Regards, Muneer
A amrit1186 Member Apr 17, 2013 #3 Hi Khushboo Please see the below link. http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/ Amritansh
Hi Khushboo Please see the below link. http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/ Amritansh
