• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Chart / Dynamic Ranges.

S

Sarravana Kumar

New Member
Hi all,

I have a table with Business Units of My Company as Legend Entries and Management Levels as Horizontal Categories Axis Labels, when I create a chart at times, there may be only 4 Business Units and sometimes 6, I want to display 4 business units only when 5th and 6th business unit does not have people against the management level.

Thanks a lot for your time.
 

Attachments

  • Excel Query.xlsx
    14.7 KB · Views: 5
In the attached, pivot chart at cell M22 of pivot table at cell B22.
In the background is a Power Query query which (a) unpivots your source data, (b) outputs to a pivot table! Options in the pivot table allow hiding/showing items with no data.
Pivot tables need refreshing after the source data changes.
 

Attachments

  • Chandoo58532Excel Query.xlsx
    29.7 KB · Views: 8
You must log in or register to reply here.
Back
Top