I have a master list of data for a group of vendors. The columns are titled
Jan thru December. I am tracking how many invoices each vendor has per month.
I filter the list by vendor and copy and paste each vendors data to a
seperate tab. I then create a chart from that data and copy it to a seperate
spreadsheet.
When I have multiple spreadsheets open at the same time the charts all get
updated with the vendor I am currently working on.
Is there a setting in excel to turn off the link between the "master
chart" and its copies?
ANy assistance is appreciated.
Thanks