ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Not showing blanks for 1 out of 2 series in a chart (https://www.excelbanter.com/charts-charting-excel/255888-not-showing-blanks-1-out-2-series-chart.html)

Cas

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