RE: Diagram with constant values in the background
- From: Luke M <LukeM@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 15 Jan 2009 12:16:10 -0800
In short, you can't. You need to tell the chart to look somewhere to display
a constant value.
Possible workaround:
If you've set the scale yourself, and its not automatic, perhaps you can
just draw a line and position it on the chart where you would like? You could
then select both the lines and the chart and group them together so that they
move as one.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"taxidimu" wrote:
I am working with MSExcel 2003..
From a table I create a graph, no matter the kind of graph.
Say that the scale is 0 to 100 and the number of values is 20.
That is:
X: 1, 2, ..., 20
Y: 10, 56, ..., 2
In the backgound I need to display some constant values, for example
to show min and max acceptable values. This can be defined by a single
value for each line.
That is:
Min: 30
Max: 90
How can I define to the chart these values, without having to add more
columns (min, max, ...) to the table and fill in them, and to refer to
them in the chart?
Thank you.
tax
- Follow-Ups:
- RE: Diagram with constant values in the background
- From: Dave Curtis
- RE: Diagram with constant values in the background
- References:
- Diagram with constant values in the background
- From: taxidimu
- Diagram with constant values in the background
- Prev by Date: RE: How do I create a bubble graph
- Next by Date: RE: Another prob with combination chart
- Previous by thread: Diagram with constant values in the background
- Next by thread: RE: Diagram with constant values in the background
- Index(es):
Relevant Pages
|
