Hello guys,
how do I remove zeros from a chart?
I did the following: Options -> Advanced -> "Display options for this workbook" -> untick "show a zero in cells that have zero value".
OUTPUT -> the table source of the chart doesn't display the zeros, however the chart does it.
Any suggestions?
One trick is to push from the data table to a chart-building table, and use a boolean IF while filling the chart-building table to replace values you wish to exclude with an error code. =IF(A1 =0, #N/A, A1) or something like that.
Charts completely skip error codes, so that should generate the chart you want.
Of course, filling a table up with error codes means any further function handling will need to wrap error handling.
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
it works perfectly, thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks