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?
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?