2 Replies Latest reply on Dec 29, 2016 1:25 AM by Eason Huang

    how can pie chart present a default shape when no data match after filtering

    Eason Huang

      I want to show a pie chart with default shape when there is no data match after filtering. how can I implement it?

       

      1. in USA sheet,  the filter has data, so it can draw a pie chart:

      piechart-with-data.png

      2. in Japan sheet, it has no data after filtering, so it can't  draw a pie chart:

      piechart-without-data.png

       

      3. for "No data" case after filtering, I want to show a default shape instead, just like below: how should I do it ?

      piechart-defaultshape.png