Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Charting
How do I get source data to show on a chart only if greater than z
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Bernard Liengme, post: 2645280"] In place of zero (or empty cell) use =NA(). This displays as #N/A and is ignored by chart Alternatively, activate the chart; use Tools | Options and open the Chart option tab. There you can specify how empty cells are to be treated best wishes [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Charting
How do I get source data to show on a chart only if greater than z
Top
