Hi All

Hoping you can help?

I am creating a combo chart form a picot table which will show price of goods and then the amount of those goods that have been sold. Setting up the chart is no problem and it looks good for what I want.

However! I have a lot of data so I don't want to show it all on one chart, instead I have groups that I want to alternate between to look at different types of data. When I choose a different group though the whole chart defaults back to a column chart and i need to go through the full exercise of creating a combo chart again.

Has anyone come across this before and have any possible solutions. I have tried recording a macro but this is also very hit and miss.

Any help will be greatly appreciated.

Thanks
Stuart