How to Copy and Align Charts and Shapes in Excel
4

How to Copy and Align Charts and Shapes in Excel Dashbords

Bottom line: Learn a few quick tips for working with multiple charts and shapes in your Excel Dashboards.

Skill level: Beginner

Align Excel Charts and Shapes to Perfection

Select Multiple Charts or Shapes

The first step in working with multiple charts or shapes is selecting them.  To select multiple objects:

  1. Select a chart by left-clicking the border with your mouse.
  2. Hold down the Ctrl key.
  3. Select another chart/shape.

Both charts will be selected and you can move, copy, align, or delete them.

Hold Ctrl to Select Multiple Charts or Shapes in Excel

Quickly Copy Charts with the Ctrl Key

The Move+Ctrl method is a quick way to make a duplicate copy of a chart.

  1. Select a chart by left-clicking the border with your mouse.
  2. Move the chart by dragging it with the mouse.
  3. Hold down the Ctrl key. An outline of the shape will appear.
    Note: You must move the chart first before pressing the Ctrl key.
  4. Release the left mouse button to make a copy.

Drag and Ctrl to Copy Charts and Shapes in Excel

Ctrl+D is another shortcut that will make a duplicate copy of the chart.  You will typically still have to select and move the new chart though.

Copy and Align Chart or Shapes with Ctrl+Shift

This is one of my favorites because it keeps your charts or shapes aligned to perfection.

  1. Select a chart by left-clicking the border with your mouse.
  2. Move the chart by dragging it with the mouse.
  3. Hold down the Ctrl and Shift keys. An outline of the shape will appear.
  4. The new shape will stay aligned (either vertically or horizontally) with the original shape.
  5. Release the left mouse button to make a copy.

Drag and Ctrl Shift to Duplicate and Align Charts in Excel

This one is great because it saves a step of then having to align a chart after you make a copy.  It’s a great trick to use when creating panel charts or dashboards.

Align Charts or Shapes with the Align Buttons

The Align buttons are located on the Format tab of the ribbon when multiple charts or shapes are selected.  I frequently use these buttons to get my dashboards and reports looking just perfect. 🙂

  1. Select multiple charts using the Ctrl keys.
  2. Select from the Align options on the Format tab of the ribbon.

Align Multiple Charts or Shapes with Align Buttons in Excel

The Distribute buttons on the Align menu are also great for making the space between shapes equal.

Free Webinar on Dashboards

My friend Mynda Treacy from My Online Training Hub has a great webinar on how to create a dashboard in Excel.  The webinar is going on right now and will only be available for a short time.

Here is a video with a little more info.  I also show a shortcut to copy and align your charts in the video.

This is basically an hour long training session on how to create dashboards in Excel, and you will learn a ton.

Click the link below to register for the free webinar.

Free Excel Dashboard Webinar

Click Here to Register for the FREE Dashboard Webinar

Please leave a comment below with any questions.  Thanks!

Please share
Jon Acampora
 

Welcome to Excel Campus! I am excited you are here. My name is Jon and my goal is to help you learn Excel to save time with your job and advance in your career. I've been an avid Excel user and VBA developer for 10+ years. I am also a Microsoft MVP. I try to learn something new everyday, and want to share this knowledge with you to help you improve your skills. When I'm not looking at spreadsheets, I get outdoors and surf. :) more about me

Click Here to Leave a Comment Below 4 comments
Israel Onoriode Ugbo - August 26, 2017

You are great Jon

Reply
Miguel - April 16, 2015

Very useful because enhances productivity.

I’m curious, what software do you use to make those beatiful screencasts with animations?

Thanks,

Miguel

Reply

Leave a Reply: