Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

9 points

How to represent empty cells on line chart?

I am building a blood pressure spreadsheet and a companion line chart. When I forget to take a reading for a day and have an empty cell the line chart has a break in continuity. Is there a way to continue the line chart from one cell w/data, past an empty cell to another cell with data, and keep the line intact?

iMac, Mac OS X (10.6.7), 27" iMac 3.06 GHz Core 2 Duo, 8GB 1

Posted on Dec 29, 2011 8:36 AM

Best reply

Barry

Level 9

59,861 points

Posted on Oct 13, 2017 12:31 PM

Hi Sophie,

Here are two examples. Both start with the same table, shown here with gaps in the data (and the resulting xy scatter plot with connecting lines):

Method 1:

Delete the lines containing no data in column C (or enter only the dates in column B for which there is data to be entered in column C):

Method 2:

Incude a line for each date, enter amount data only in lines for dates when there is data to enter.

Filter the table on column C to show only the rows containing data (Note line numbers in the tabs to the left of the table).

Note that the dates in column B are:

Date and Time values (formatted to display only the month and day)
in a body column, where they will be read as data, not a header column, where they would be read as categories (text).

There is a checkbox in the Chart Format Inspector labelled "Hidden Data". It is unchecked by default, and should remain so when using Method 2.

Regards,

Barry

View in context

17 replies