All of the Pivot Chart examples we’ve been through in prior videos involved creating a Pivot Chart and the related Pivot Table from scratch. What if you already have a Pivot Table you’ve been using and want to create a Pivot Chart? You don’t have to start over. Watch Excel Video 29. Simply select an area of the Pivot Table by highlighting some cells, then tell Excel you want to create a chart by selecting the type of chart you want from the Insert menu. Excel’s smart enough to recognize that the chart is based on Pivot Table data and creates a Pivot Chart for you to work with. In this example, we’ll create a bar chart and compare reimbursement percentages for the five clinic physicians over a three year period.
My experience is that charts can often display trends and make comparisons more quickly and clearly than tables of data. Physicians with limited time to focus on clinic details will really benefit from graphical presentations emphasizing key medical metrics. If the physician needs more information or wants to see the data sliced a different way, Pivot Charts are very easily to modify quickly while you’re sitting with the physician. If for some reason the charts don’t have enough detail, the underlying Pivot Chart is only a click away. I think you’ll find Pivot Charts to be a very efficient way to organize and present clinic information. Pivot Charts are a great way to turn numbers into knowledge.