PivotChart: Show Work as Stacked Column and Capacity as Line RRS feed

  • Question

  • Hi,

    I have created view like the resource availability view with Excel PivotChart. I'm showing the work as stacked column by projects. If I add the capacity I get it stacked, too. How ever I'd like to show the capacity only as one line. How can I achieve this?



    Saturday, December 1, 2012 3:17 PM

All replies

  • Hi Peter,

    in a pivot chart, you can right-click the bar for one of the bars, select change series chart type and select e.g. a line chart. If the Project List hierarchy does not change, applying these changes to all capacity bars should work.

    Note that if your goal was to have a unique chart style for both measures in a pivot chart based on OLAP data in general, this is not possible in Excel as far as I know. However, in this situation, I would suggest creating a calculated measure which displays work as a fraction of capacity.

    Kind regards,

    Tuesday, December 4, 2012 12:23 AM