One rogue data point in new 2 axis line chart

Hi All,

I'm still using Excel 2002, so try not to laugh. I have a table that's 7 x 26500 for logging my blood pressure and weight. Just added the weight column about 300 cells ago. At that time, I graphed my weight in a simple 1-axis chart, which works as expected. Now I've decided to make a new 2-axis chart with X = date and Y = weight. It all came out the same with one exception. There is a "stuck" data point on this new chart that's there (but wrong!) and cannot be cleared. From the table, it's row #1384 which has my weight at 223.6 while the chart value shows 216.8. I can (temporarily) delete this row and multiple rows above and below it, yet the chart value persists. I will attach a screen shot as the actual worksheet has too much personal data to scrub. FYI, the longer dip was when the wife was hospitalized for a week...

The weight range is identical on both 1x and 2x charts, the 2x has a date range equal to the weight range with "A" column subbed for "G" column. Hope this enough info.

TIA!

Russ

Image 001.jpg

Searching "216.8" did it, thanks! I found that I'd dropped a zero from what was supposed to be 11/20/21 so it ended up as 11/2/21. Since my table is unordered, the row with the rogue cell was in an unexpected place, searching found it, and correcting it put the point in the correct location on the chart.

Russ