-2

I have the following stacked column chart (bar graph) in Excel: enter image description here

The problem is that the chart data labels (percentages right on the green bars) do not fit and overlap. Data labels positioned horizontally. I want to position them vertically, but I couldn't find a way to do it in settings.

Question: how to position/place chart data labels vertically in Excel so that they fit in bars?

Moderators! Can you delete the question entirely? I see that SO community want so much to close it. Next time I will not ask such questions here. I better try on more adequate communities like quora or reddit.

Uploaded Excel file to DropBox: 4.14SO.xlsx

Erba Aitbayev
  • 4,167
  • 12
  • 46
  • 81
  • 1
    This question is off-topic for [SO] and I have voted to close it. – talonmies Apr 04 '17 at 05:44
  • Then tons of other similar questions must be deleted and closed. But they are kept. Double standards in action. – Erba Aitbayev Apr 04 '17 at 05:46
  • Explain how this is a programming related question. – talonmies Apr 04 '17 at 06:03
  • Here on stackoverflow enormous number of questions that are not quite about programming. But the questions are not closed. But for some magical reason some questions are heavily donwvoted and closed while other similar questions are kept and open. May be someone better explain why such double standards in SO and why for some questions rules are followed while for others these rules ignored. – Erba Aitbayev Apr 04 '17 at 06:11
  • So you basic defense here to agree that this is off-topic, but say there are lots of other off-topic questions, so therefore you are the victim of a double standard? You are more that welcome to escalate your complaint to https://meta.stackoverflow.com/ – talonmies Apr 04 '17 at 06:39
  • As for your now deleted complaint about close and downvotes. Yesterday I downvoted and voted to close about 50 blatantly off-topic questions tagged with [excel][graph]. If you have asked other questions. If you have asked other questions about charts in excel which fall into this category, then yes I probably downvoted other questions of yours. – talonmies Apr 05 '17 at 06:15
  • Why still not deleted the question. Delete it. Close it. Whatever you like to do. – Erba Aitbayev Jan 06 '18 at 19:28

1 Answers1

0

Follow these steps...

Right click Data Labels --> Format Data Labels --> On Format Data Label Window, choose Size & Properties tab --> Alignment --> In there you can change the text direction of data labels as per your requirement.

Subodh Tiwari sktneer
  • 9,906
  • 2
  • 18
  • 22
  • SO community discourage people from answering questions by donwvoting answers. It is the only place where I see such mean behaviour. – Erba Aitbayev Apr 04 '17 at 16:26
  • Cool down Chichi! Every forum has it's own rules and regulations and both the asker and the solution provider should follow them. I would suggest you to follow the guidelines for asking a question in this forum. That will help you and others as well. Have a good day! :) – Subodh Tiwari sktneer Apr 04 '17 at 16:35
  • But the problem is that for some questions rules completely ignored. While for others not. – Erba Aitbayev Apr 04 '17 at 16:42
  • No worries. Each day thousands of questions are opened in the forum and it's not possible to track each question for a single person to make sure the rules are not violated. So if others are not following the forum guidelines that's their problem and they will face the consequences later or sooner. The bottom line is to learn from mistakes and move ahead. :) – Subodh Tiwari sktneer Apr 04 '17 at 16:49