• 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

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

  • w3.jpg
    w3.jpg
    41.1 KB · Views: 10
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
 
ps:
Once your chart is complete you can drag the columns back to there original positions if required
upload_2017-10-25_15-10-3.png

see the file attached
 

Attachments

  • Chart.xlsx
    14.2 KB · Views: 5
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

  • Chart-2.xlsx
    14.3 KB · Views: 5
Right click on the Data Labels
Select Format Data Label
You should be able to rotate it somewhere in there
 
You must log in or register to reply here.
Back
Top