Not showing blanks for 1 out of 2 series in a chart
I have understood the use of NA(), but since I also want to show the data
table, it is not a nice looking solution. I have a monthly chart showing several years for comparison, but I do not want the last month for current year to drop down to zero. How can I avoid this without showing #N/A in the data table? |
All times are GMT +1. The time now is 12:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com