I have a pivoting table and a line chart that plots the results of the selection made for the filters of the table. The solution proposed here http://www.excelforum.com/excel-char...-or-blank.html doesn't fully work for historical data plotting and hence for a line chart. Can someone give me a suggestion of how to adapt the solution above to my case or propose another approach?