tag:blogger.com,1999:blog-10630343.post6188373249489996941..comments2023-10-03T09:34:09.673-07:00Comments on content divergent: Little excel tips: display no value for zero, automatically add daterobinhttp://www.blogger.com/profile/10333235736833054873noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-10630343.post-45907505143538337702008-07-24T04:51:00.000-07:002008-07-24T04:51:00.000-07:00Hi there,Thanks for letting me know. I hadn't ...Hi there,<BR/>Thanks for letting me know. I hadn't thought about what happens if you take the data and pull it through to a graph or chart. I think there are a few ways around this using either some scripting or a filter. <BR/><BR/>Try this:<BR/>Select your chart > Tools > Option > Chart, Plot Empty Cells <BR/><BR/>(choose: not plotted)Robinhttps://www.blogger.com/profile/02475205435808073017noreply@blogger.comtag:blogger.com,1999:blog-10630343.post-24688930652996987892008-07-23T04:57:00.000-07:002008-07-23T04:57:00.000-07:00Nice. But, unfortunately, if you are charting the ...Nice. But, unfortunately, if you are charting the data the "" blank still looks like 0 to the chart code. I'm looking for something the chart code would treat like a blank cell.Anonymousnoreply@blogger.com