4 Replies Latest reply on Apr 24, 2013 4:28 AM by Ashish Agrawal

    Pie Chart sizing

    Ashish Agrawal

      I have raw data spread across years. A sample worksheet is attached.

      I have created pie charts for last & current year data and the size of the sector changes for different selections.

       

      However, one challenge that I am facing is, For eg: I try to select Shanghai from the drop down filter I have created. Note that Shanghai had no sales (let's call it) in current year. In this case, the pie chart size changes abruptly to a very small circle.

       

      Any solution/workaround?