Chart Data Entries

[Edsaid]

I have prepared an Excel chart to monitor blood pressure; morning, noon and night. The daily readings show okay but after the last entry, the chart lines dive to the bottom of the chart for the remainder of the dates. Not serious as regards the data but looks awful. Can anyone give me the tip to have the chart lines stop at the last entry...?

Thanks in advance for any help...

Ed

[sandy666]

..............use =NA()

[Edsaid]

Thanks Sandy, but can you tell me where...?

This formula is used to produce the morning sample reading: =SERIES("Morning",'Systolic Chart'!$C$4:$C$35,'Systolic Chart'!$D$4:$D$34,1)

Please be patient with me. I'm over 80 and it's many years since I messed with Excel...!!

[sandy666]

Ok, no problem
Could you attach example excel file (not a picture) ?

To attach a Excel file to your post,

• click Go Advanced,
• scroll down until you see Manage Attachments,
• click that and select Browse,
• select your file and click Open,
• click Upload and you will see your attachment below Upload Files from a website
• click Close this window,
• click Submit reply

After that you should see attachment in your post

[sandy666]

or better if you see example without and with NA()

[Edsaid]

Thanks, Sandy.

I hope it's there somewhere. Can't see it...! ps: Showed up after I submitted...

[sandy666]

.....................
your formula contain an #REF! error. You hide it by Conditional formatting but chart read it as blank cell or not recognized value so there was line fall down to x-axis
#N/A must be visible for chart and you can hide it by CF (btw. enough to make font white without background ) but it must be there
eg. your serie range of values for Morning is ='Pulse Pressure'!$E$4:$E$34 and it should contain values or N/A only (not any other things) from the start to the end

The last thing you do is formatting. Do it only when everything is working properly

for Diabolic BP

before:	and after	before chart	and after chart
before.jpg	after.jpg	beforechart.jpg	afterchart.jpg

see differences?

here is

[Edsaid]

You'd make a brilliant forensic detective, Sandy... :

Thanks a million. Now it looks perfect...

Best wishes, Ed

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[sandy666]

You are welcome Ed,
If that takes care of your original question, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you) then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED. Thanks.

[sandy666]

Thanks for the feedback and mark thread solved
Greets 2 you Ed