|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 12th, 2009, 03:58 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
How do I assess whether something falls into an area on a chart?
I have drawn a graph with 3 almost parallel lines on. I would like to be able
to put in a result, eg 4.6 @ 6hrs and for excel to say whether it is under the bottom line or in-between two lines or above the top. Any thoughts please? 
|
|
#2
August 12th, 2009, 09:39 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I assess whether something falls into an area on a chart?
You need to do that on the worksheet with the data, not on the graph.
-- David Biddulph Zef wrote: I have drawn a graph with 3 almost parallel lines on. I would like to be able to put in a result, eg 4.6 @ 6hrs and for excel to say whether it is under the bottom line or in-between two lines or above the top. Any thoughts please?
|
|
#3
August 13th, 2009, 05:39 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I assess whether something falls into an area on a chart?
Excel 2007 Chart
Assess target area. With Tables, CF and colored target areas. http://www.mediafire.com/file/qnwmoy...08_12_09a.xlsx
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
