View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Cas Cas is offline
external usenet poster
 
Posts: 12
Default 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?