Using same dataset for multiple charts

%3CLINGO-SUB%20id%3D%22lingo-sub-2543511%22%20slang%3D%22en-US%22%3EUsing%20same%20dataset%20for%20multiple%20charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2543511%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%20I'm%20embarrassed%20to%20be%20asking%20this%20because%20I%20use%20to%20be%20pretty%20good%20with%20Excel%20but%20I%20need%20help!%3C%2FP%3E%3CP%3EI%20need%20to%20create%20multiple%20charts%20from%20data%20in%20my%20worksheet.%20Data%20source%20for%20a%20chart%20is%20defined%20by%20filtering%20the%20data%20in%20the%20worksheet.%20I%20get%20the%20first%20chart%20created%20but%20as%20soon%20as%20I%20filter%20the%20data%20to%20create%20the%20subsequent%20charts%20my%20previously%20created%20charts%20get%20messed%20up.%3C%2FP%3E%3CP%3EDo%20I%20need%20to%20break%20the%20original%20data%20into%20new%20worksheets%20to%20create%20the%20new%20charts%20without%20affecting%20the%20previous%20charts%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ERob%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2543511%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2561431%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20same%20dataset%20for%20multiple%20charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2561431%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1102439%22%20target%3D%22_blank%22%3E%40Jazzlover%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20default%20behavior.%20To%20avoid%20the%20situation%20you%20need%20to%20get%20image%20for%20chart%20and%20place%20on%20sheet.%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20image%20purpose%20I%20am%20using%20following%20charting%20tool%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fchartexpo.com%2FutmAction%2FNCtNVEMreGwrUUorTVNPRlRDTVQr%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EFor%20Excel%20%26amp%3B%20Office%20365%3C%2FA%3E%26nbsp%3B%20and%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fchartexpo.com%2FutmAction%2FNCtNVEMrZ3MrUUorTVNPRlRDTVQr%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EFor%20Google%20Sheets%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20it%20will%20help%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E
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