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?



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.