2 Replies Latest reply: Aug 12, 2011 7:45 AM by deborah83 RSS

    Create a special type of chart in a Table

      Hi,

       

      I'm trying to create a chart based on de pivot table

       

      It would look like this:

       

       

      Year

      Month

      TaskType

      Days Spent on Project

      Days spent on Sales

      2010

      Jan

      Project

      Sales

      Feb

      Project

      Sales


      I'm using this formula: if(Tasktype='Sales', sum(DaysSpent). I would present the measures with a line-meter so i would look like mini-barcharts.

      Is this possible to do?

      Thankx!