Hi, I have a pivot chart that has multiple filters on it. In this chart, I've created a user-defined chart (an area and line chart combination with a secondary Y-axis value) and made it the default chart. My problem is whenever I change the filter in the chart, the chart changes back to an area graph with only one Y-axis value. Does anyone know how I can set the chart so it stays in the same chart format each time I filter?
Thanks! Paul.