Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I specify a constant Y-value for an X-series
I am using an XY (scatter) chart to plot eight time-stamped events (series).
I want the Y-value for each event to be a constant so I can use different colored error bars with different heights to show the event/series on my chart. Currently I have filled columns with the desired constant value (4, 6, 8, 10, ...) for each X-series and use these columns to supply the constant Y-value. There must be a simpler way to accomplish my objective. If I provide the constant as, for example, 6, to the Y-series, it uses this value only for the first x-series point. I want it to use this value for all the x-values in the series. Is there a simpler way to make this happen? Any assistance would be greatly appreciated as I have not been able to figure out how to do this! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I specify a constant Y-value for an X-series
Hi,
There is no built-in way of specifying a single value to be plotted over multiple points. Using a multiple cells with a single value is the simplest way. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Cinco" wrote in message ... I am using an XY (scatter) chart to plot eight time-stamped events (series). I want the Y-value for each event to be a constant so I can use different colored error bars with different heights to show the event/series on my chart. Currently I have filled columns with the desired constant value (4, 6, 8, 10, ...) for each X-series and use these columns to supply the constant Y-value. There must be a simpler way to accomplish my objective. If I provide the constant as, for example, 6, to the Y-series, it uses this value only for the first x-series point. I want it to use this value for all the x-values in the series. Is there a simpler way to make this happen? Any assistance would be greatly appreciated as I have not been able to figure out how to do this! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I specify a constant Y-value for an X-series
Hi,
If you show us a sample of the data layout it may be clearer. As I hear it you have a variable 4,6,... constant. So I'm confused - is it a variable or a constant? The data layout might answer that question. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Cinco" wrote: I am using an XY (scatter) chart to plot eight time-stamped events (series). I want the Y-value for each event to be a constant so I can use different colored error bars with different heights to show the event/series on my chart. Currently I have filled columns with the desired constant value (4, 6, 8, 10, ...) for each X-series and use these columns to supply the constant Y-value. There must be a simpler way to accomplish my objective. If I provide the constant as, for example, 6, to the Y-series, it uses this value only for the first x-series point. I want it to use this value for all the x-values in the series. Is there a simpler way to make this happen? Any assistance would be greatly appreciated as I have not been able to figure out how to do this! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill a series keeping the last number constant | Excel Discussion (Misc queries) | |||
User Selectable Series and Number of Series for Line Chart | Charts and Charting in Excel | |||
Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
Constant loan payments vs. constant payments of principal | Excel Worksheet Functions | |||
series graph -- one series being added to another series | Charts and Charting in Excel |