Chart Series from single value

[Nigel]

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?

 

[Jon Peltier]

I usually advise people to use as many cells as makes what they want easy.
You can use this approach:

http://peltiertech.com/Excel/Charts/AddLineHorzErrBar.html

to add a horizontal line from a single Y value cell, or this approach:

http://peltiertech.com/Excel/Charts/AddLineHorzSeries.html

to add a horizontal line from two Y value cells (use a formula in the second
to link to the value in the first), or simply use formulas to fill as many
cells with the value as you have categories, add this range as a new series,
and convert the series to a line chart type.

- Jon

 

[Nigel]

Thank you

--

Regards,
Nigel
(e-mail address removed)