I have a dynamic named range which I am trying to use as the source data for a stacked bar chart. The named range covers a number of rows with data in them (in multiple columns).
Each row is currently shown on the graph as an individual series. In the first column of the named range are the names of each row's data (which translates to the chart as the series names in the legend), the remaining data is made up of numbers.
The number of rows included in the named range is variable depending on what year it is and also whether or not a new row is added.
I would like the chart to automatically pick up that either another row has been added to the named range, constituting another series, or a row has been taken off the named range, making that series disappear. I can't get the chart to use the named range I currently have.
Does anyone know of a non-VBA way of making this work?
Thanks,
H
Each row is currently shown on the graph as an individual series. In the first column of the named range are the names of each row's data (which translates to the chart as the series names in the legend), the remaining data is made up of numbers.
The number of rows included in the named range is variable depending on what year it is and also whether or not a new row is added.
I would like the chart to automatically pick up that either another row has been added to the named range, constituting another series, or a row has been taken off the named range, making that series disappear. I can't get the chart to use the named range I currently have.
Does anyone know of a non-VBA way of making this work?

Thanks,
H