Autoupdate Chart

Hi,

Only option I am aware is to increase the cell range in your formulas to include the blank space. This will help in updating the chart automatically, i.e as and when you enter the data in the cells.

See attachment, I have updated for "Control chart Inventory levels", as and when you enter the data in column B(red colored cells), graph would auto populate.

Hope this helps!!

I imagine that there's a few different ways to go about this.

I would probably do the following.


Don't pre-fill the dates. Enter all dates as actual dates, not text with an asterisk. If you need the asterisks, put them in a separate column right next to the date column.

Use autofilter to display 'top 10' items in the date column. Have user click dropdown button, select top ten then set the number of items as applicable. You could also do it programatically based on the value in the 'number of weeks' cell.

Right click the charts, select 'format chart area' and select 'don't move or size with cells'. Re-do the source data ranges to encompass the entire range including empty cells at the end. When you display on the top x number of weeks it will only chart those weeks.


I think that should work anyway.

Thanks everyone. Based on some of the comments and about 8 hours of playing with it I finally got it to work.