BoostExcel.com main content

Snap Data Sheet and Chart Sheet Side by Side

The two worksheets "Flow Data*" and "Flow Chart*" contain related information. If you need to switch between them frequently, try the "Snap Side by Side" command.

This command places the pair of chart sheet and data sheet side by side on the screen. This enables you to review / work on both sheets without switching back and forth. It is extremely useful if you have a large screen.

Snap 2 sheets

Use Excel's "Zoom" Command

If you have a large diagram, try Excel's "Zoom" command. To access this command:

  1. Make sure the active sheet is a flow chart sheet.
  2. Go to Excel’s "View" ribbon tab.
  3. Choose the zoom level, or type in your custom zoom level.
  4. To restore 100% zoom, simply click the "100%" button on the same ribbon section.

Change Connection Site

The app uses an automated algorithm to avoid crossing connectors. But in rare cases there are still crossing lines appear on the chart. Fortunately, changing connection site could fix many of them.

Different shape types have different numbers of sites. For example, the rectangle (flowchart shape "Process") has 4 connection sites; the "Summing Junction" shape has 8 connection sites.

To change a connection site:

  1. Click a connector to select it.
  2. Click and push down your mouse key on the starting point or the ending point of the connector. Don't release mouse key.
  3. Drag the point to the target shape. The connection sites of the shape appear. Dragging the line starting point to a shape
  4. Move your mouse to the desired connection site, release the mouse key.
  5. Now the dragged point of the connector line (either the ending point, or the starting point) is "connected" with the site. If you move the shape, the connected point will flow it too.

Select One Shape

Be sure to click a location near the border of the shape. If you click the center of the shape, Excel thinks you want to edit the text and thus put the embed text box into editing mode, instead of selecting shape.

Select Multiple Shapes

Often you want to apply the same modification to multiple shapes, for example moving multiple shapes, changing the background color of multiple shapes etc. Before doing that, you first need to select multiple shapes.

One way to do that is to use one of the "Select" command on the "Flowchart" ribbon. For example, if you want to select "Shape A" and all the shapes to the left of the that shape, you first select "Shape A", and then click the "Left" button on the "Flowchart" ribbon tab.

If this does not work for you, you can also select shapes one by one manually. To do this, simply push down CTRL key on the keyboard and then click each shape.

With the CTRL key pushed down, clicking a selected shape will unselect it.

Align Shapes

To align multiple shapes on the same row or column, first select the shapes as described above.

Then go to Excel's "Shape Format" menu, click "Align" on the "Arrange" group. Choose "Align Center" or "Align Middle" as you required.

Align shapes command

Change Connector Type

The auto-generated shape uses the connector type selected on the ribbon option "Connector Type". Once the chart is generated, you can still change the connector types.

To do this, First, select all the connectors by clicking the "Connectors" command on the "Select" group of the "Flowchart" ribbon tab, or select one or multiple connectors manually.

Then, right-click one of the selected shapes, choose "Connector Types" from the menu.