14 Replies Latest reply: May 7, 2018 7:10 AM by omar bensalem RSS

    creating pie chart choosing multiple column

    celine xu

      Hi,

      wondering do you have any suggestion creating a pie chart using multiple column without change the data structure

      Having data structure like this, need to create other dashboard so can not change the structure :

       

      Screen Shot 2018-05-05 at 15.37.41.png

      Each row are each individual haveing A--G costs. and Total =sum(A:G) --Total is total cost

       

      is there any chance can create pie chart for each individual t1, t2.....(will use filter for this so only need one pie chart)

      showing the decomposition of the Total cost. So we do not need the total cost but have A:G in the same pie chart and see the %

       

      here is the data (in the second sheet: name 'sheet 1')

       

       

      Thank you.