print message

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

stan

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional number format of x-axis based on value? 1
Data Labels Disappearing 0
How do I make x-axis dates in area chart not start from/drop to ze 5
Position vertical axis 5
Gradient Line Chart not Working 1
Can conditional formatting be used to format chart elements? 1
Hide Graph of Data Outside X-Axis Range 2
Excel Macro to automatically go to the right of the last colored cell 0

Top