On the add-in window press the “Move Selected Object with Arrow Keys” button.Select the element in the chart you want to move (title, data labels, legend, plot area).To move the elements inside the chart with the arrow keys: The window contains two main features: Move Objects with Arrow Keys and Alignment Buttons. This is a contextual tab and will only appear when you have a chart selected.Ĭlicking on the Align Objects button will open the add-in window. The add-in is compatible with Excel 2007, 2010, and 2013 for Windows.Īfter you have installed the add-in, the Align Objects button will appear on the right side of the Format tab in the Chart Tools design tab of the ribbon. This will save you time and take out some of the guess work with arranging the elements. For example, every single chart you produce in the future can have a chart title that is offset 5 points from the top-left corner of the chart border. The Chart Alignment add-in helps make this process faster and gives your charts a more standardized and professional look. This requires you to modify the chart layout, especially the chart elements. The default settings for Excel charts don't always apply to some of these theories of reducing chart junk and keeping it simple. There is a lot of great information about this topic and I will post some links at the bottom for further reading. The reader should be able to understand the message you are trying to convey within a few seconds of looking at the chart. The goal of any chart is to clearly communicate a story about your data. The margin setting allows you to set the margin to a specific number of points that will offset the chart element from the chart border.

How to angle text in excel 2013 graph