Chart Series from single value
 

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

Chart Series from single value
 

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/...orzErrBar.html

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

http://peltiertech.com/Excel/Charts/...orzSeries.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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Nigel" wrote in message
...
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

Chart Series from single value
 

Thank you

--

Regards,
Nigel




"Jon Peltier" wrote in message
...
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/...orzErrBar.html

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

http://peltiertech.com/Excel/Charts/...orzSeries.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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Nigel" wrote in message
...
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