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

Unable to Make a Dashboard with Contribution %

Hi Excel Guru,

Attached is a file with a data.
I was trying to make a Dashboard as well wanted to put a contribution% side by side.
But after making Pivot Table I am unable to link the same. After that I wanted to make a Chart ( Any Chart ) which will clear the picture to everyone whether the trend is good or bad. The chart should contain Data Label so that its clear what was the position last month and whats the position this month.

Therefore I request you to kindly help me in making the dashboard.

Thanks
Raj
 

Attachments

  • 06XLS.xlsx
    36.5 KB · Views: 15
See attached. Wasn't clear on whether you wanted contribution of reason among all the reasons within the month or contribution of the reason per month based on total for the reason so created 2 versions.

Also, didn't add a chart as it looks pretty congested. Added in a sparkline (in-cell chart) instead and some conditional formatting so that bad numbers kind of pop-out. See if it is helpful.
 

Attachments

  • 06XLS_VD.xlsx
    56.1 KB · Views: 16
Rush,
I'm not really sure if this is the one that you are looking for. See attachment.
 

Attachments

  • 06XLS.xlsx
    42.5 KB · Views: 20
Back
Top