I'm charting blood pressure for my MD as a 90-day project. Everything functions and displays perfectly except for two separate x axis data points that plunge the charted blood pressure lines to zero (but I'm not dead yet). How can I remove those two mysterious entries? They' don't appear inthe files data table.

Could you possibly upload the file?

xor,

Thanks for your interest and help! Please see attached file. Comments, etc are redacted to remove personal medical information, but the chart and its complete data cells are included.

Attached Files

Clonidine upload file for xor.xlsx (24.6 KB, 12 views)

The null values correspond to the rows containing text ( 16 and 74)
Remove them and the null values dissappear

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Chart range should start in row 17 I think.

Attached Files

Clonidine_2.xlsx (24.9 KB, 6 views)