Hello, I am trying to use the NA() formula in the data series of a line chart to prevent the chart from plotting empty cells, but it is not working. Can someone take a look at the attached file and let me know what I am doing wrong?
Thanks!
Hello, I am trying to use the NA() formula in the data series of a line chart to prevent the chart from plotting empty cells, but it is not working. Can someone take a look at the attached file and let me know what I am doing wrong?
Thanks!
If your formula leaves the NA cells empty you should be able to select the option to show empty cells as gaps.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
Change the sub type of the chart from Stacked Lines with markers to Clustered Line with markers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks