Interactive charts

Hi David, thanks for the query. You can select a data series on a chart simply by clicking on data record (say, a column on a column chart) the rest of the series will also then be selected and you could then format the entire series as a line. Coding-wise, you can build a macro to do this for you (say, when you are coding the construction of a chart from scratch). Other than that, let us know if this info is enough or whether you need anything more specific.

Hope this helps,

Anthony