Colleagues:
I need your help on an Excel 2013 charting issue. It gives with one hand but, takes with the other.
I have an Excel 2013 chart which drops values to zero where there is no data displayed in a particular cell, for the current year. One of your solved threads mentions scatter charts to solve the issue. However, this didn't work with my issue.
To graphically describe this; I've attached a desensitized spreadsheet, to illustrate the issue.
Many thanks in advance for any help your are able to offer.
David2020.
Bookmarks