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?