Posts by dkabambe

    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.)


    Thanks, Dzinja