Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to plot column chart with one series against multiple series. | Charts and Charting in Excel | |||
Change chart type in single data series, Excel 2007 | Charts and Charting in Excel | |||
define chart series from single column | Excel Discussion (Misc queries) | |||
Displaying single and multiple data series.Single data series | Charts and Charting in Excel | |||
chart data series -- plot a table as a single series | Charts and Charting in Excel |