| Tip of the Month Archive |

Creating Multiple Panel Graphs in Excel

  1. Create the first graph and indicate that it should be located in the open (data) spreadsheet (the default option).

    Excel Screenshot

  2. Copy the graph by right-clicking on the graph area and selecting copy from the pop-up menu. Paste it in the upper left corner of a new spreadsheet by right-clicking on a cell and selecting paste from the pop-up menu.

    Excel Screenshot

  3. Create additional graphs as required, locating them in the open (data) spreadsheet. Copy these additional graphs to the spreadsheet with the first graph and place them adjacent to the previous graphs.

    Excel Screenshot

  4. Select all the graphs on the spreadsheet by holding down the <Ctrl> key and left-clicking on each graph. Right-click on one of the charts and select Grouping => Group from the pop-up menu to group the graphs into a single graphic image.

    Excel Screenshot

  5. Resize the single graphic image to occupy the full page, maintaining the original proportions. (Format => Object => Size => Lock Aspect Ratio)

    Excel Screenshot

 


Recently Viewed Series


Subscribe to our newsletter for updates on published research, data news, and latest econ information.
Name:   Email:  
Twitter logo Google Plus logo Facebook logo YouTube logo LinkedIn logo