Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How do I move superposed values in a bar chart?

Hello everyone


I have created a bar chart but the values appearing in one of the columns, are superposing each other. This is how it looks like:


User uploaded file


Is there a way to move those 3 "2,13%" or place them in a different way so it will be readable?


Thank you in advance for the help guys!


Tiago

MacBook Pro, Mac OS X (10.6.4)

Posted on Mar 25, 2014 12:26 PM

Reply
Question marked as Best reply

Posted on Mar 25, 2014 12:35 PM

Some data don't lend themselves to this type of annotation. You could try stretching the vertical axis of the chart.


Jerry

4 replies

Mar 25, 2014 2:46 PM in response to Iceblog

You can always do the annotations manually with text boxes if this is an important publication. You can clip off the bottom of the range with a Minimum Axis setting to exaggerate the differences at the top of the bars. Experiment with setting the labels at the different position options.


For instance, if you have three stacked series, set the lower values to Bottom, the middle series to Middle and the top series to Top. That will spread them out a bit.


Jerry

How do I move superposed values in a bar chart?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.