I have a series of charts (Bar-Line) embedded on a worksheet.

The bars in each chart represent monthly values and are dynamically set
using VBA code, this works well.

The line needs to extend across the chart for the number of months in the
chart, the value of this line is the same at each point and is stored as a
single value in one cell on the worksheet.

Is this possible?

--

Regards,
Nigel