Select Page

This is one of those videos that may take a minute to load. Excel Video 28 is an extended example of how to use a Pivot Chart. There are a couple of ideas demonstrated that I hope you’ll find helpful. We look at E&M codes by the coding level (the last digit of the E&M code) by physician to see the differences in how the clinic’s physicians are coding their visits. You’ll see how to look at the E&M visits as a percentage of the row to capture the percentage of each of the five coding levels. Once we have the Pivot Chart close to the way we want it, watch how to move the chart to a separate tab in the spreadsheet. If your charts have as much data as our sample chart does, you’ll find it helpful to have the additional room that comes from showing the chart on its own tab.
Once we get the chart on a separate tab, it would be helpful to switch rows and columns to better understand the individual physicians’ coding patterns. Watch how easy it is to switch the rows and columns, but also note that since we were looking at coding levels as a percentage of the row, when we moved coding levels we also had to tell Excel to calculate the values as a percentage of the columns, instead. Also watch how easy it is to use the Filter Pane to focus on smaller groups of physicians without having to leave the chart page.
Most of Excel 2007’s charting options work just fine with Pivot Charts. The next time you’re working with a Pivot Table, add a Pivot Chart to make your presentation easier to visualize and understand.