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

Help for draw dashboard

hoomantt

Member
Hi dear professors,
in attached picture i have a table that first column is name of some goods and the second column is the share of every one in my company sales.
and want to draw the left chart that shows share of every goods in my sales.
please,Please,Help me
thanks
 

Attachments

Hui

Excel Ninja
Staff member
Rearrange your data as
upload_2017-10-25_14-59-30.png

Select the data and goto the Insert, Chart, Stacked Bar Chart
upload_2017-10-25_15-1-19.png

Select the Chart
Right click on the Chart and Select Data Source
Click on the Switch Row/Column
upload_2017-10-25_15-2-52.png

Right click on each Color, Add data Label
Select the Data Label
Right Click the Data Label, Format Data Labels
Click Series Name
Unclick Value
upload_2017-10-25_15-5-3.png

Enjoy
upload_2017-10-25_15-7-49.png
 

hoomantt

Member
Dear Hui
Thanks a lot for your help.
I dont know what i say for thank you
thanks a lot
i have anothar problem.
the name of my goods are long and they will go togeather and user can not undersatnd the chart.
is there any way to wrap these names or rotate 90 degree ?!
hanks alot
 

Attachments

Hui

Excel Ninja
Staff member
Right click on the Data Labels
Select Format Data Label
You should be able to rotate it somewhere in there
 
Top