You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

Pages - dots on chart not connecting

Hi,


I am attempting to create a chart on pages, however, the dots on the chart are not connecting. Only some of them are? Does anyone know how this may be fixed?


I have attached a picture of the chart and data.


Ethan


MacBook Air 13″, macOS 11.4

Posted on Mar 29, 2022 5:18 AM

Reply
Question marked as Top-ranking reply

Posted on Mar 30, 2022 12:12 AM

HI Ethan,


I suspect this is happening because of the breaks in your data.

All Three data sets use the same set of Y values.


Ux has data for the first two Y values, an these two data points are connected. There is no data for the next five Y values, so they are left blank, and do not generate a connector.

Uy also has data for two consecutive Y values, then a mixture of empty cells and isolated single data points, and the chart exhibits the same behaviour as above.

Uz differs in 'data spacing,' with three consecutive Y values having X data values, which are connected by lines, followed by a single isolated data point displayed with no connection to the empty cells between it and the third data point.


You can get connecting lines between all data points in a series by making a different chart for each series, and leaving no gaps in the X and Y pairs in each data list. With care,those charts can be stacked with the Y and Z charts showing through the X chart. the care to be taken is mostly a matter of matching the size of each chart so that each has the same scale (and the same limits) for each axis), and removing any unnecessary details that are the same for each chart, but would be difficult to keep aligned in all three charts.


Others may have a simpler solution. This one is a bit complicated and finicky, and not one that I've used recently.


Regards,

Barry


1 reply
Question marked as Top-ranking reply

Mar 30, 2022 12:12 AM in response to ethanc348

HI Ethan,


I suspect this is happening because of the breaks in your data.

All Three data sets use the same set of Y values.


Ux has data for the first two Y values, an these two data points are connected. There is no data for the next five Y values, so they are left blank, and do not generate a connector.

Uy also has data for two consecutive Y values, then a mixture of empty cells and isolated single data points, and the chart exhibits the same behaviour as above.

Uz differs in 'data spacing,' with three consecutive Y values having X data values, which are connected by lines, followed by a single isolated data point displayed with no connection to the empty cells between it and the third data point.


You can get connecting lines between all data points in a series by making a different chart for each series, and leaving no gaps in the X and Y pairs in each data list. With care,those charts can be stacked with the Y and Z charts showing through the X chart. the care to be taken is mostly a matter of matching the size of each chart so that each has the same scale (and the same limits) for each axis), and removing any unnecessary details that are the same for each chart, but would be difficult to keep aligned in all three charts.


Others may have a simpler solution. This one is a bit complicated and finicky, and not one that I've used recently.


Regards,

Barry


Pages - dots on chart not connecting

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.