Not showing blanks for 1 out of 2 series in a chart

C

cas

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Gantt chart duration not showing 0
Create a chart from a table in word thats dynamic 0
Chart SERIES OFFSET 5
Convert Error Bars to Series and Colour 1
Creating a Chart on form from selected data in query. 0
#N/A plotted as 0 on line chart 0
Employee Schedule not plotting properly - chart type / data series not correct 0
How to getting text labels to show up in scatter chart. 0

Top