Benches Uncategorized

3

Lines are not connected in numbers

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

Please help! I want straight lines to show up.

3 replies

Sign in or join Beachball Help to reply.

  1. 0

    SGIII

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Not sure how you got the points to plot that way. Using the same data I get this:

    Click a series in the chart and in the Style tab choose 'Straight' for Connection Line.

    Result:

    Repeat as needed for the other data series.

    SG

  2. 0

    Yellowbox

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi arpankanungo,

    Some thoughts:

    • The chart (graph) looks like a Scatter Plot with Column B (7 Days) as the X axis and Column C (28 Days) and Column D (56 Days) on the Y axis.
    • Column A (Percentage) appears to be a Header Column. It does not appear to be included in the graph.
    • Are there merged cells in the data?
    • What do you see when you click on Edit Data References? Does it look like this (X Y Y)?

    By the way, I changed the number of Steps on the X axis to 6 and the numbers of Steps on the Y axis to 5 to make it easier for we humans to read.

    What is your overall aim?

    Regards,

    Ian.

  3. 0

    Badunit

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Like SGIII said, select the chart, go to the Series tab on the sidebar, and set Connections Lines to "straight" or "curved". The only thing I would add is that if you select the chart as a whole, not a specific series, when you make this change it will do it for all of the series at the same time vs having to do each individually.