In this step-by-step tutorial, you will learn how to create a panel chart in all versions of Excel: 2003, 2007, 2010, 2013, 2016, and 2019. Excel Panel Chart Template - Free Download A panel chart (also known as a small multiple, lattice chart, grid chart, or trellis chart) is a set of small graphs placed next to each other that use the same scales and axes for comparing similar categories across a data set. The goal of a panel chart is to help you quickly compare multiple sets of closely related data without overwhelming you with its volume or taking up too much precious dashboard space. As a general rule, the more data series you have mapped out on your plot, the messier it gets\u2014but not in the case of lattice graphs. Enough of the theory. Let's move on to the practice. By the end of this tutorial, you will create this panel chart from the ground up\u2014even if you are a complete Excel newbie: Sample Data To walk you through the process, we need some data to work with. In order to build our panel chart, we\u2019ll use some random data on historical stock price trends scraped from the Web: Before we dive in, here\u2019s the breakdown of this table to help you know what we\u2019re working with: Column A (Company): This column maps out the categories that will be compared with each other across all the sections of the future grid chart.Column B (Year): This column represents the y-axis of our panel chart; for your panel chart to make sense, you need to measure your data with the same yardstick.Columns C and D (Year High and Year Low): These columns determine the actual values; the beauty of the technique you\u2019re about to learn is that you can use as many columns as you want. Now that we\u2019re on the same page, let\u2019s get down to business. Step 1. Create the Separators Our first step is to add a helper column with alternating separators to split the table into four separate sections (panels). Next to your data table, create Column E (Separator).For each of the categories in Column A, assign a custom value\u2014either \u201c1\u201d or \u201c2\u201d\u2014to each of the companies in the table in alternating order as shown in the screenshot below. Once there, your data table should end up like this: Step 2. Create a Pivot Table Next stop: create a pivot table based on the expanded table. Select any cell in the data table (A1:E21).Navigate to the Insert tab.Choose \u201cPivotTable.\u201d In the dialog box that pops up, set up your pivot table by following these instructions: For the \u201cTable\/Range\u201d field, highlight the entire data table (A1:E21).For where to place the table, select \u201cExisting Worksheet.\u201dPick any empty cell in your worksheet.Click \u201cOK.\u201d The moment you close the dialog box, the PivotTable Fields task pane will appear. In the task pane, you\u2019ll need to rearrange the layout in the following way to lay the groundwork for your small multiples: Shift the columns around in the exact same order as shown below (it\u2019s important): Drag \u201cCompany\u201dand\u201cYear\u201d to \u201cRows\u201d (with \u201cCompany\u201d on top).Drag \u201cYear High\u201dand\u201cYear Low\u201d to \u201cValues.\u201dDrag \u201cSeparator\u201d to \u201cColumns\u201d and place it above \u201cValues.\u201d Doing all of that will result in this pivot table: Step 3. Format the Pivot Table Now that you have put together the pivot table, let\u2019s get rid of the elements we don\u2019t need. Start by removing the subtotals: Select the pivot table.Go to the Design tab.Open the \u201cSubtotals\u201d dropdown menu.Click \u201cDo Not Show Subtotals.\u201d Next, remove the grand totals: In the same tab, select \u201cGrand Totals.\u201dChoose \u201cOff for Rows and Columns.\u201d Finally, convert the pivot table into tabular form: Again, in the same tab, select \u201cReport Layout.\u201dClick \u201cShow in Tabular Form.\u201d By the end of this stage, your pivot table should look like this: Step 4. Rearrange the Pivot Table (Optional) Provided you have followed all of the steps outlined above, Excel should automatically position the categories in alternating order using the separators. But that doesn\u2019t always happen. If you ever get stuck at this stage, here\u2019s a quick-and-dirty way to fix the issue: Right-click on the name of the category you want to move up or down (such as \u201cTesla\u201d).Choose \u201cMove.\u201dIn the menu that appears, select \u201cMove \u2018Tesla\u2019 Down.\u201d Armed with this simple technique, you can quickly and easily rearrange the pivot table so that the categories are arranged in alternating order. Step 5. Prepare the Chart Data At this point, you need to separate the data from the pivot table to be able to use it for building your grid chart. To start with, drop the sorted data in the pivot table into empty cells somewhere near it (Copy > Paste Special > Values). After that, copy the column labels characterizing the actual values (\u201cYear High\u201d and \u201cYear Low\u201d); since the dividers split the data into two separate data sets, you need to duplicate the labels as well. NOTE: The values in the header row will be used for generating the legend of your panel chart. Step 6. Create a Panel Chart At last, after all that preparation, you can now get down to building your panel chart: Highlight the freshly created table (N3:S23).Go to the Insert tab.Click \u201cInsert Line or Area Chart.\u201dChoose \u201cLine.\u201d And there you have your lovely panel chart: Step 7. Adapt the Color Scheme Basically, the trellis graph is a set of two simple line charts. For that reason, before we can call it a day, we need to add a bit more consistency to the color scheme to make the graph readable. To recolor your data series, right-click on any of the lines charted on the plot area and click \u201cFormat Data Series.\u201d In the Format Data Series task pane that appears, do the following: Switch over to the Fill & Line tab.Open the palette and pick the color you want.Use the chart legend to double-check the color consistency. Step 8. Clean Up the Chart Legend Finally, remove the redundant legend labels. Select the legend label you want to remove, right-click on it, and choose \u201cDelete.\u201d Spruce up the graph with a custom chart title, and your panel chart is ready to go: (Bonus) Step 9. How to Create an Excel Panel Chart with Different Scales If you\u2019re wondering how to create a panel chart with different scales, you\u2019ve come to the right place. For those who jumped straight to this section, first you need to build your panel chart using the step-by-step process outlined above\u2014and before you close this article in a blind panic, know that this should only take a few minutes. Once we\u2019re on the same page, to plot your panel chart on two separate scales, right-click on the chart plot and choose \u201cChange Series Chart Type\u201d from the menu that appears. In the dialog box that pops up, chart some of the data series on the secondary axis: Switch to the \u201cCombo\u201d tab.Check the \u201cSecondary Axis\u201d box next to a set of identically named data series\u2014in our case, Series \u201cYear Low.\u201dClick \u201cOK.\u201d Finally, you have a clean, neat-looking panel chart with different scales ready to blow everyone away!