View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
taxidimu taxidimu is offline
external usenet poster
 
Posts: 4
Default Diagram with constant values in the background

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