Update Pivot Table Dynamically when a column is inserted to dataset

[Dan Swartz]

I have a need to have a pivot chart update dynamically when a column is inserted. I have not found a way to do this.

Basically, I have an Ice Cream Shop that keeps track of how many scoops of ice cream are served each day. So they have a long. the flavors are across the top with dates being vertically in column B. Along the way, they add a new flavor. so a column is inserted. the problem is the pivot tables will not automatically update to include the new column and flavor. It has no problem adding rows. it's just columns. Is this doable?

As you can see in the picture, Berry Starburst and Crazen are new flavors. but these will not update in the pivot chart automatically.

 

[shift-del]

Your structure is already a crosstabular list and NOT suitable for a pivot table - as you expierienced.
You need to unpivot your data into a dataset list which only grows in rows.

 

[Dan Swartz]

Your structure is already a crosstabular list and NOT suitable for a pivot table - as you expierienced.
You need to unpivot your data into a dataset list which only grows in rows.

I was afraid of that! Ok