print message

[stan]

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?

 

[teylyn]

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


Is it possible to conditionally format a chart so that it prints a

 

[stan]

works-thanks so much
--
stan

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



Is it possible to conditionally format a chart so that it prints a


--
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

.