Category Archives: Pivot Chart

How to Fix a Pivot Chart All Columns One Color

After you create a pivot table, you can insert a pivot chart, based on that pivot table. In this example, the chart shows sales data, per city, over two years. See how to change the chart layout, after you build … Continue reading

Posted in Pivot Chart | Leave a comment

Combo Column Line Pivot Chart in Excel 2013

Long ago, there was a Chart Wizard in Excel, and it had some built-in Combination Chart Types, like Column-Line. The Chart Wizard disappeared in Excel 2007, along with the combo chart type options. You could still create combo charts in … Continue reading

Posted in Pivot Chart | Leave a comment

Compare Years in Pivot Chart

A pivot table is a quick and effective way to summarize data, and you can also create a pivot chart, to show a visual summary. And, if you’re summarizing the data by date, you’ll usually need to group the date … Continue reading

Posted in Pivot Chart | 2 Comments

Create Pivot Chart from Data in Excel 2013

With a new feature in Excel 2013, you can create a pivot chart right from the source data – you don’t have to build a pivot table first. You can watch this short video tutorial, to see how it works, … Continue reading

Posted in Pivot Chart | Leave a comment

Changing Pivot Chart Affects Excel Pivot Table

After you create a pivot table, you can insert a pivot chart, based on that pivot table. However, if you change the layout of the pivot chart, it will also change the pivot table’s layout. For example, if I remove … Continue reading

Posted in Pivot Chart | Leave a comment

Show Survey Responses in Pivot Chart

I’ve updated one of the pivot chart sample files on my Contextures website. On the main sheet, there are two pivot charts, showing survey responses by department, and by years of service. At the top of the sheet, you can … Continue reading

Posted in Pivot Chart | Leave a comment

Create Pivot Chart with Shortcut Keys

The quickest way to create a chart in Excel is by using a keyboard shortcut. With the following shortcuts, you can create a chart on a separate sheet, or place it on the same sheet as the data. Create a … Continue reading

Posted in Pivot Chart | 1 Comment

Change Pivot Chart Source Data

In an Excel file, you might have a couple of pivot tables on different worksheets. If you create a pivot chart for one of those pivot tables, you might spend a long time setting it up, with specific formatting and … Continue reading

Posted in Pivot Chart | 5 Comments

Change Number Format in Pivot Chart

When you create a pivot chart from a pivot table, the numbers on the chart’s axis are in the same format as the pivot table’s numbers. In the screen shot below, the numbers are in General format, with no comma … Continue reading

Posted in Pivot Chart | Leave a comment

Changing Pivot Chart Layout Affects Pivot Table

If you rearrange the fields in a pivot chart layout, the related pivot table changes too. Unfortunately, there’s no setting you can change if you want the pivot chart and pivot table to work independently. As a workaround, you can … Continue reading

Posted in Pivot Chart | Leave a comment