print message

  • Thread starter Thread starter stan
  • Start date Start date
S

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?
 
works-thanks so much
--
stan


teylyn said:
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

.
Click to expand...
 
Back
Top