1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

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

Discussion in 'Excel Dashboards' started by hoomantt, Oct 25, 2017.

  1. hoomantt

    hoomantt Member

    Messages:
    84
    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

    Attached Files:

    • w3.jpg
      w3.jpg
      File size:
      41.1 KB
      Views:
      10
  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    10,932
    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
    Thomas Kuriakose likes this.
  3. Hui

    Hui Excel Ninja Staff Member

    Messages:
    10,932
    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

    Attached Files:

    Thomas Kuriakose likes this.
  4. hoomantt

    hoomantt Member

    Messages:
    84
    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

    Attached Files:

  5. Hui

    Hui Excel Ninja Staff Member

    Messages:
    10,932
    Right click on the Data Labels
    Select Format Data Label
    You should be able to rotate it somewhere in there
  6. hoomantt

    hoomantt Member

    Messages:
    84
    Dear Hui
    Thanks again
    That was so helpful
    Thanks

Share This Page