Instead of having all the data in a single column, it is broken into two columns, by adding a “Stagger” field in the source data.Īfter adding the “Stagger” field, create a pivot table from the data, with City and Order date in the Row area, Stagger and Category in the Column area, and Total Sales in the Values area.Īfter the pivot table is finished, copy the data, and paste it as formatted numbers on another worksheet. The secret to separating the groups in a panel chart is “staggering” the data in the pivot table. Or, follow along as I build a line panel chart in the video, further down in this article. There is an overview of the steps below, and you can see the detailed instructions on my Contextures website: Excel Panel Charts
Add final formatting to clean up the chart. 
Add another series to create vertical dividing lines. Create a line chart from the copied data. Add a separator field to the source data. We can group the instructions into the following main steps: Last week, I finally took the plunge, and it’s not so bad, once you get the big picture in your head. The instructions for making a panel chart look long and complicated, and I’ve avoided learning this technique, because it was a daunting process. I learned this technique from Jon Peltier’s website, where he also sells an Excel Chart Utility, that creates complex charts quickly. My panel chart shows sales for bars and cookies, in four cities, over the first 7 months of the current year. It shows all the data in a single chart, with vertical lines separating the groups. To show a concise, clear summary of data for several departments or cities, you can create a panel chart in Excel.
0 kommentar(er)
