How-to Line Up Your Excel Worksheet Embedded Charts

Have you ever created a lot of charts in an Excel Worksheet and drove yourself crazy trying to line the charts up?

Learn Excel Dashboard Course

image.png

Notice how the charts above are all not in perfect alignment?  Well, here is a quick tip on how to align your Excel charts.

 

Excel (as well as most the Microsoft products) has a wonderful Align feature that you can use on Shapes, Text Boxes and Charts.  You may not believe it, but many Excel users do not know that this feature exists, so lets see how to do it.





 

To align your charts in a straight fashion, you will want to do the following:

1) Select one chart

Learn Excel Dashboard Course

2) Hold the Shift key down or Hold the CTRL key down.

3) Select the second chart to align



4) Choose the Format Ribbon, then choose the Align menu in the Arrange group and then pick your alignment type.

Note: You typically want to only pick the charts that will be aligned during a one plane.  For instance, in this picture below, I would choose Align Top since the charts are on the top of my chart area.  Then I would move around and choose the two right charts and align them right, then choose the two bottom charts and align them to the bottom and finally the two on the left with Align Left.

Excel Chart Align Top Menu

Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy

 

Video Tutorial





 

So in the future, don’t drive yourself mad with trying to manually align your charts with your mouse.  Use the Align feature instead.  Now given that we may use the Align features in the Align menu, let me know if you ever use the other Align menu options like: Distribute Horizontally or Vertically or Snap to Grid or Snap to Shape.  I am not sure how much these items may get used.  Perhaps Distribute Vertically or Horizontally are used when people build swim lanes process flows in Excel.  Not sure the best use cases for snap to grid or snap to shape, but let me know what you think in the comments below.

Learn Excel Dashboard Course

 





If you found the website and tutorials helpful, please consider donating to keep the lights on.

Donate with PayPal here:





Steve=True





Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy

7 COMMENTS

  1. One thing I always do before aligning charts or objects is make sure they are all the same size. One being off by just a fraction of an inch can make all the work you’ve done aligning the objects for aesthetic reasons unsuccessful.

    It might also be helpful to point out that when you use the align buttons, it aligns all selected objects with the one that is the furthest in that direction (ie: if you select align left, it will move all of the objects up so that the left edges align with the one that was the furthest to the left.)

LEAVE A REPLY

Please enter your comment!
Please enter your name here