Scribd
Upload
18 views1 page

Adjusting Bar Chart Label Positions

By changing the Axis option to Text, the columns in a simple column chart return to their normal thickness from being compressed. This document provides two methods for customizing axis labels in bar charts - the first allows changing the label position to avoid labels being hidden by negative bars, while the second also enables reversing a series for additional customization. Steps are outlined for setting up sample data and applying the first method to reposition axis labels on a basic bar chart.

Uploaded by

mudassir2640
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
18 views1 page

Adjusting Bar Chart Label Positions

By changing the Axis option to Text, the columns in a simple column chart return to their normal thickness from being compressed. This document provides two methods for customizing axis labels in bar charts - the first allows changing the label position to avoid labels being hidden by negative bars, while the second also enables reversing a series for additional customization. Steps are outlined for setting up sample data and applying the first method to reposition axis labels on a basic bar chart.

Uploaded by

mudassir2640
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Figure 5-54.

Simple column chart with Axis changed to Text

By changing the Axis option to Text, the columns return to their normal
thickness.

Hack #68

When you create a bar chart, the position of your axis labels is automatically determined. However, depending on your chart requirements, you
might want to change how or where your labels are displayed. To make your
chart more professional, here are two methods you can use to change how
your labels are set. The second method also reverses a series.

Changing Label Position


When you create a bar chart with both positive and negative values, the bars
are formed to the left or to the right of the axis. Because negative value series
created in a bar chart will be colored and formed to the left of your X axis,
they will hide the axis labels. Using this method, you can reformat where
your labels are positioned.
Set up some data as shown in Figure 5-55, and create a basic bar chart on
the range A1:B6.

You might also like