I hadn't seen the earlier posts in this thread until today.
I use complex Excel spreadsheets on a daily basis and I would like to make two observations:
Cells C2-4, G2-4, K2, K4, M2, M4, B7 and B8 are referenced using "Defined Names"
1. In my experience, using Defined Names and/or Defined Ranges is a recipe for disaster when it comes to trouble shooting.
2. If you are creating a chart that duplicates a printed one, for QC purposes, you can clip an image of the printed chart along the X and Y axes and display the clipped image as the background of your Excel XY chart.