I have a pivot table that has the below fields

month
team

and data sets for

match win %
game win %
winnings

and would like to have a separate chart created for each team on the same
page without having to manually create each chart. I can create a single
chart easily, with the win % items on the left axis, month on the bottom and
winnings on the right axis. I have created a customer chart type for this,
although I have to manually change the chart type when data is refreshed.

I would like to have Excel automatically create all of the charts, and
adjust the axis according to the data for that team, and also to keep the
chart type when updating. So I have 3 problems. Please help! Thanks.