Relative Content

Tag Archive for excelvbachartslegendseries

Adding new chart series but excluding them from the legend

VBA. I’m trying to edit a chart by adding multiple new series to indicate when certain phases begin at certain times. I’ve done this by writing code that creates series using x values of the date i.e. (10/1/24 to 10/1/24) and y values -1000 to 1000 to create a vertical line. However I was wondering if there was a way to exclude these new series from the legend, as the legend gets too large, and the plot is running slowly – causing difficulties with manually deleting legend entries.