Using same dataset for multiple charts

Occasional Visitor

Hello all, I'm embarrassed to be asking this because I use to be pretty good with Excel but I need help!

I need to create multiple charts from data in my worksheet. Data source for a chart is defined by filtering the data in the worksheet. I get the first chart created but as soon as I filter the data to create the subsequent charts my previously created charts get messed up.

Do I need to break the original data into new worksheets to create the new charts without affecting the previous charts?

Thanks

Rob

1 Reply

Hi @Jazzlover 

 

This is default behavior. To avoid the situation you need to get image for chart and place on sheet. 

For image purpose I am using following charting tool 

 

For Excel & Office 365  and 

 

For Google Sheets 

 

I hope it will help you.

 

Thanks