My issue is that I have a chart that I need to change based on the values in a certain range. I originally built the chart with the date values being keyed in. Now when I change those keyed cells to equal another dynamic cell it messes the whole chart up.

Here are pictures showing what happens when I change the keyed in date value to equal another cell.

Good.JPG

Bad.JPG