Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Diagram with constant values in the background
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Diagram with constant values in the background
Your max and min lines on the chart need to have a source for the data they
plot, but you can do it with a single point, rather than whole columns of figures. Enter 30 in a cell, and add the point as a new series. The format the series to have horizontal error bars of whatever length you want. Repeat for your max figure of 90. Dave "Luke M" wrote: 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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Diagram with constant values in the background
I just posted this link as an answer to another post:
http://peltiertech.com/Excel/Charts/AddLine.html Here's another possibility: http://peltiertech.com/Excel/ChartsH...orizBands.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Dave Curtis" wrote in message ... Your max and min lines on the chart need to have a source for the data they plot, but you can do it with a single point, rather than whole columns of figures. Enter 30 in a cell, and add the point as a new series. The format the series to have horizontal error bars of whatever length you want. Repeat for your max figure of 90. Dave "Luke M" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I show hour values in a diagram | New Users to Excel | |||
How to replace numeric values with letters in a diagram? | Excel Discussion (Misc queries) | |||
Keep lookup values constant | Excel Discussion (Misc queries) | |||
Find data in table with to set of constant values | Excel Worksheet Functions | |||
Diagram row values | Excel Worksheet Functions |