none
Can't use headers in legend fields

    Question

  • 

    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

Answers

  • 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.


    http://darren.gosbell.com - please mark correct answers

    Sunday, March 16, 2014 10:38 PM
    Answerer