Is it possible to have a dynamic [line] chart which automatically recognises when new series are added to the data set? I have a data sheet with dates along row 1, and series names down column A.
However, I never know how many series I'm going to have in the data set, as that comes from lookups dependent on users criteria.
I can write a quick bit of VBA code in the Chart_Activate procedure to update the data source whenever the chart is viewed. However, I would ideally like to avoid VBA if possible. (It's not just me using the file, and many people have their security set to High.)