Excel: How to Exclude Specific Columns From a Pivot Chart

[@IglesiaNuevaJerusalen-lk1vi]

I did not know i could just copy the pivot table and start another analysis from ther, thanks Doc, appreciate, keep up the good work

[@lele5697]

thanks for showing how to use the overlap formatting - this worked!

[@MikeThomas67]

You're welcome!

[@aymeetolander]

Hello, with the third method, creating a chart instead of a Pivot Chart, will that chart auto-update if changes occur?

[@maciejkopczynski55]

Hi Mike! I have a question regarding the last method. Assuming we add one more store location to our source data, will the series and Y axis labels dynamically expand? Per my tests the new positions won't be included, and the selection area stays static even though it belongs to a pivot.

[@MikeThomas67]

@maciejkopczynski8677 Did you mean will the X axis labels expand? (the locations are on the X - horizontal axis). If that's what you meant the answer is yes - as long as the pivot table is based on a Table

[@pandamonium9834]

Afterwords Mike hope that you guys are okay? Thanks for this new video as always very useful

[@MikeThomas67]

Yes we are