I'm trying to get a combo chart to automatically add new data series into it when the underlying named range is expanded.
My excel chart is a simple combo chart with one series as a line (max capacity) and all other series as a stacked area chart (one series per project). This would allow me to easily see where the sum of the different projects exceeds my max capacity at any point in time.
See example:
My problem is tho that when I add a new range to the base table the chart does not automatically update.
All other chart types seem to expand, and I've seen multiple posts suggesting ways of fixing this for other charts (including the named range trick). However the behavior for a combo chart seems to be different.
Does anyone have any suggestions?
Dynamic Named Range
,, will always use the new set of data for the set procedure when included !!