Analyzing Data With Lots of Blank n/a Cells

[Holeshotking48]

Hi all,

I have a lot of BP data gathered but it has a lot of blanks on dates where no Blood Pressure values were ever taken. I have graphed the data in order to try to analyze it, but it's hard because all of the blank cells show up as n/a or 0s.

Does anyone know what i could do in order to have the n/a or 0s in my data not show up in the graph? Any input/ideas would be greatly appreciated!

Thanks for your time,
M

 

[TheCman81]

Does the data in your graph obtained through a formula? If so you can use IFERROR within your formula!

 

[Holeshotking48]

Does the data in your graph obtained through a formula? If so you can use IFERROR within your formula!

I'm not using any sort of formulas.

 

[circledchicken]

Does anyone know what i could do in order to have the n/a or 0s in my data not show up in the graph? Any input/ideas would be greatly appreciated!

Hi,

Perhaps try hiding any rows you don't want to show up in the graph.

 

[RJPotts]

Hi all,

I have a lot of BP data gathered but it has a lot of blanks on dates where no Blood Pressure values were ever taken. I have graphed the data in order to try to analyze it, but it's hard because all of the blank cells show up as n/a or 0s.

Does anyone know what i could do in order to have the n/a or 0s in my data not show up in the graph? Any input/ideas would be greatly appreciated!

Thanks for your time,
M

Are you wanting the blanks to show as gaps in the graph? Or to not be considered at all?

Best regards
Richard

 

[Holeshotking48]

I am wanting the blanks to not be considered at all.

Thanks,
M

 

[RJPotts]

I am wanting the blanks to not be considered at all.

Thanks,
M

Are you wanting to leave the n/a / 0 entries in your original data? Can you post a sample of how your data is laid out and a rough indication of the range the data covers?

Best regards
Richard