How to prevent chart type from changing when using slicers?

[Matthew Bond]

Hey guys,

I have 4 pivot charts (clustered columns) that are all linked to several slicers. The slicers are all connected with "PivotTable Connections". On each of these charts, I'm displaying a target line, which I've formatted as a Line Chart. Any time I use the slicers the target line gets formatted as clustered column, and I can't figure out a way of preventing that.

Any help you guys can offer is very much appreciated. I've attached the workbook in question. The charts I'm referencing are under the "New Hire Status" section.

 

[Nebu]

Hi:

I guess you will have to build another chart for target and place it on the top of your existing graph and make it transparent.

Thanks

 

[Matthew Bond]

That's a great idea! I wouldn't of thought to do that. Thank you!