ExcelBanter - Combination chart in Pivot

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Combination chart in Pivot (https://www.excelbanter.com/charts-charting-excel/49587-combination-chart-pivot.html)

Help with Pivot Chart- Combination

Combination chart in Pivot

Hi,

I want to use a line and bar combination chart in a Pivot Chart but
everytime I refresh the report it reverts back to bar chart. Is there any way
I can fix the chart format?

Jon Peltier

This is a known issue with pivot charts:

http://pubs.logicalexpressions.com/P...?ID=209#jon026

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Help with Pivot Chart- Combination wrote:

Hi,

I want to use a line and bar combination chart in a Pivot Chart but
everytime I refresh the report it reverts back to bar chart. Is there any way
I can fix the chart format?

All times are GMT +1. The time now is 06:46 PM.