I am using excel 2010 to chart some data. In my data range when I have a zero, I'm replacing it with NA().
When I bar chart my data, it does not show the zero. However, when I change it to a line chart hey presto that zeros appear.
Can anyone get me out of this?
Thanks in advance for your help, v. much appreciated.
That does not sound like the expected behavior at all. In similar situations, my version of Excel ignores those data points (see this article http://peltiertech.com/mind-the-gap-...g-empty-cells/ ).
Can you upload a sample spreadsheet illustrating this behavior?
Originally Posted by shg
Hi Mr Shorty, sadly I can't upload a workbook as the settings at work don't allow this.
Thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks