Combination Pivot Chart

runesund

New Member
Joined
Nov 21, 2005
Messages
1
I have a combination pivot chart which combine a horizontal line (one series) and two series in columns. The problem is that every time I change the page field values the horizontal line part of chart changes automatic to column...

Does anyone have any ideas to solve this without VBA? Any workaround where I can get a different horizontal line for each page field will work?
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,114,051
Messages
5,545,724
Members
410,702
Latest member
clizama18
Top