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!

5 comments

Your email address will not be published. Required fields are marked *

Search
Generic filters
Exact matches only
Filter by Custom Post Type

JOIN US & LEARN EXCEL

Learn 10 great Excel techniques that will wow your boss and make your co-workers say, "how did you do that??"
Plus weekly updates to help you learn Excel.

Download the eBook

About Me

Jon Acampora Profile

Hello and welcome! My name is Jon Acampora and I'm here to help you learn Excel.

This blog is updated frequently with Excel and VBA tutorials & tools to help improve your Excel skills and save time with your everyday tasks. Subscribe above to stay updated. More about me...

MVP_Horizontal_BlueOnly

Macros and VBA Training Webinar