How do I add a dotted line or dashed line to one section of an x,y line graph? I am plotting change in production (y) across time, x, and the most recent production total is an estimate, so I want the last line of the graph to indicate that somehow -- dashed line or a dotted line?
MacBook Pro (13-inch Mid 2009), OS X El Capitan (10.11.3)
I suggest using two series: one for the actual data, and a second for the estimated data:
Then you can select the series on the chart, and use the Style formatter for that series to change the line characteristics. You will have to turn on connecting lines in the Style formatter ("Connection Line" set to "Straight" in this example)
Many thanks, and for the screengrab. I made a second series (40,000) but I can't work out how to connect the first series with the second. (Also, excusing ignorance, I don't know why the top row is highlighted dark blue...well, obviously I'm a beginner here...)
Hi captiver,
I don't know why the top row is highlighted dark blue...
That is a Header Row, and it hasn't plotted. A header row can be used for labels.
With the table selected, set Header Rows to 0
(or move the data down one row).
Regards,
Ian.
Ahh… I see what you mean.
It may have to do with the first row having been a Header row. When you changed it, the change may have also affected Numbers recognition of A1 as still a member of a Header column. Note that all labels are shifted one data point to the left, and there is no label for the last point.
Here's what it should look like:
To create this chart, enter the data as shown. Select cells B2-C12, then choose the Line Chart from the Charts button menu. (Note that the category labels for the x axis are in a Header column.)
I changes the Stroke of the last connecting line from solid to dashed, and the colour for that line and it's data point symbols from the default green to the same blue as the first series.
To label all of the data points, I then chose the box containing the category axis labels, then changes the label orientation from Horizontal to Vertical Left, using the pop-up menu in the Inspector. Here's the result:
Regards,
Barry
Thank you @Barry, and everyone. Above and beyond. I have it, thanks to all your kind Numbers 101 help. Voila!! And handy tip about the horizontal/vertical axis categories. As you can tell, I'm kind of learning as I go -- in some ways easier in Excel only because I 'know' it by necessity, but prefer Numbers. Thank you again!
Hi captiver,
What's not plotting?
I count 11 data points, 10 in the first series, 2 in the second. The tenth of series 1 and the first in series 2 are in the same position, so they display as a single point.
Regards,
Barry
notice that I entered points that overlap (with respect to the x axis) even though they are on different series.
said another way, enter the value 22.906 in the third column just above 40.000
Aaaaah, I suspected that (from using Excel) but had hunted around and failed to work out how to change it. Thank you, too, very much. Done and, I hope/thing, dusted!
Hi captiver,
Table 1 has one Header Row for the labels and one Header Column for the years.
2D Line chart.
Regards,
Ian.
Thank you, Ian. I read this out of order, and have made that change. So, here's hoping tis done.
Gratefully, Captiver
Done! I missed that entirely. Brilliant, thank you so much for your time and help.
Oh, stet that, it's still not plotting. Oy, I seem to be going backwards. Which is entirely my ignorance/doing. I'll get there, at some point...
I mean it seems they are out of sync, such that 2006-07 doesn't appear on the X axis, and the tonnage for that year instead correlates to 2007-08 for some reason.
Adding dotted line to one part of x,y line graph?
