Hi.
I have a monthly column graph. I have all the data connected to a table which populates after i type in the daily data through another worksheet. I have been able to make the table show blank cells as blank rather than as a 0.
However, when i have the graph which populates the data daily, the labels show the blank days as 0. How do i make the blank cells also appear on the graph labels as blank too?
Make the table show #N/A instead (the NA error, not simply a text entry): =IFERROR(yourformula,NA())
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
If they are data labels, you can apply a custom number format to simply hide 0 values (unless 0 is a valid value in some cases).
Rory
Hi.
Apologies. It is actually the on the graph itself and not the label. Ive managed to stop the labels from showing 0 now.
I have attached an example. This is a daily chart, so each day i update the table. However, i just want the day to be blank if no data has been inputted yet.
I seem to have got it working for the column graphs, but for the line graphs you will notice that this has not worked.
Does anyone know how to fix this and just show it as blank rather than as a marker on the x axis at 0?
Thanks.
Did you try Glenn's suggestion? You'll need a formula like:
=IF(Sheet2!D6="",NA(),Sheet2!D6)
since the source cells aren't actually blank. You can use CF to hide the NA values if you need to.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks