title: Excel Pivot Chart: remove zero values
body: <p>I have Pivot table with one Axis field (containing 13 elements 0-12) and two Values series. One of the series (A) has 13 values. The other series (B) has only 3 elements.</p>
  
  <p>When I make a pivot table, I'm able to hide the zero values using this explanation :</p>
  
  <p><a href="https://stackoverflow.com/questions/10705159/excel-2010-hide-0-values-in-pivot">Excel 2010: Hide 0 values in Pivot</a></p>
  
  <p>However when I make a pivot chart (line chart) the series B keep showing zero (or a line dropping to the x-axis). I want the line of the series B to stop when there are no values (the line should be floating on the chart).</p>
  
  <p>Anyone has an idea how to achieve this ?</p>