I have a huge workbook (several tabs and over 100 charts). Somewhere in my huge mess I have a #ref error. I believe it is on one of my charts somewhere probably hidden in the x-axis.

I have done a find to look for errors within the spreadsheet and there are none. Is there an easy way to find out where this error is within my charts other than looking at each individual chart. My guess is that the chart included a column that I have long deleted. Many of my charts have over 60 lines on them.

I have searched on google for many much with no luck for an answer, so I thought I would ask here.