Prev: Text-wrapping horizontal axis labels
Next: How come when I try to insert a chart in Excel, nothing happens?
From: stan on 29 Mar 2010 22:34
Is it possible to conditionally format a chart so that it prints a
message-like "out of range"-when source data on the y-axis falls outside a
range?
--
stan
From: teylyn on 30 Mar 2010 23:29

Hello Stan,

you could insert a text box and link it to a cell in the spreadsheet.
(ctrl-click the text box and enter =A1 into the function bar)
Then in A1 have a message appear with an IF statement

=IF(B1>100,"Values are out of range","")

Set the chart Y axis to a maximum of 100 and it will not automatically
grow with the data.

does that help?

cheers, teylyn



s
t
a
n
;
6
8
5
4
1
1

W
r
o
t
e
:


>
Is it possible to conditionally format a chart so that it prints a
> message-like "out of range"-when source data on the y-axis falls
outside a
> range?
> --
> stan


--
teylyn

Teylyn -- 'teylyn.posterous.com' (http://teylyn.posterous.com)
------------------------------------------------------------------------
teylyn's Profile: 983
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=191534

http://www.thecodecage.com/forumz

From: stan on 31 Mar 2010 11:28
works-thanks so much
--
stan


"teylyn" wrote:

>
> Hello Stan,
>
> you could insert a text box and link it to a cell in the spreadsheet.
> (ctrl-click the text box and enter =A1 into the function bar)
> Then in A1 have a message appear with an IF statement
>
> =IF(B1>100,"Values are out of range","")
>
> Set the chart Y axis to a maximum of 100 and it will not automatically
> grow with the data.
>
> does that help?
>
> cheers, teylyn
>
>
>
stan;685411 Wrote:
> >
> Is it possible to conditionally format a chart so that it prints a
> > message-like "out of range"-when source data on the y-axis falls
> outside a
> > range?
> > --
> > stan
>
>
> --
> teylyn
>
> Teylyn -- 'teylyn.posterous.com' (http://teylyn.posterous.com)
> ------------------------------------------------------------------------
> teylyn's Profile: 983
> View this thread: http://www.thecodecage.com/forumz/showthread.php?t=191534
>
> http://www.thecodecage.com/forumz
>
> .
>
 | 
Pages: 1
Prev: Text-wrapping horizontal axis labels
Next: How come when I try to insert a chart in Excel, nothing happens?