About Us

Nigel[_2_]

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to plot column chart with one series against multiple series.	svenkateshmurthy	Charts and Charting in Excel	2	October 16th 07 09:09 PM
Change chart type in single data series, Excel 2007	momof3	Charts and Charting in Excel	3	June 30th 07 02:45 PM
define chart series from single column	Maarten	Excel Discussion (Misc queries)	2	May 24th 07 08:49 AM
Displaying single and multiple data series.Single data series	Donald Macleod	Charts and Charting in Excel	2	January 30th 06 02:52 AM
chart data series -- plot a table as a single series	hjc	Charts and Charting in Excel	7	September 20th 05 05:52 PM

Menu

About Us