Can't use headers in legend fields



    Hi, I have the following data in a power pivot excel Header Columns Name of Subfocus Area Strategies Implemented Strategies in Progress Not Started Subfocus Area1 23 5 3 Subfocus Area 2 28 20 9 Subfocus Area 3 29 4 4 All I want is stacked up bar chart representing this in the image as below (sampleimage)

    which I am not able to do

    How I am doing it
    Wednesday, March 12, 2014 3:46 PM


  • If you want to see the strategy status on the legend I think you should probably structure your table like the following:

    Sub Focus Area       Status              Strategy Count

    ===========      =========     ========

    Sub Focus Area 1    Implemented       23

    Sub Focus Area 1    In Progress           5

    Sub Focus Area 1    Not Started           3

    Sub Focus Area 2    Implemented       28


    Then the status will show up as a column that you should be able to drag into the legend area. - please mark correct answers

    Sunday, March 16, 2014 10:38 PM