I have 2 questions.
I've plotted a trendline between two points on a scatter chart. How can I extend the trendline beyond just those two points without adding extra data?
My second question is how do I add another series of data points, such as another table, to plot on the same scatter chart as the first series?
MacBook, Mac OS X (10.5.8), Numbers '09 Ver 2.0.5
Kail,
you need to aggregate all the data you want to plot into the same table. You can do this by copy and paste or making one table reference the relevant portions of another table.
The first part of your question is eerily similar to another question where someone wanted to "extend" a trendline without adding extra data. I provided a way to do that and they did not like the answer because I and others suggested you cannot extend AND not add data-- they are mutually exclusive.
Please review this thread:
https://discussions.apple.com/thread/5563884?answerId=23796629022#23796629022
Wayne Contello wrote:
Kail,
you need to aggregate all the data you want to plot into the same table. You can do this by copy and paste or making one table reference the relevant portions of another table.
Wayne,
Another big loss in Numbers 3.0. No dragging X-Y data from outside tables as was possible in 2.3. Somehow I'd missed that one.
Jerry
Jerry,
I did not confirm this-- did you? I assumed (bad me, bad me) that the data should be in the same table. I think as a good design practice it is better to aggregate the data.
Wayne
Wayne Contello wrote:
Jerry,
I did not confirm this-- did you? I assumed (bad me, bad me) that the data should be in the same table. I think as a good design practice it is better to aggregate the data.
Wayne
In my opinion, it's not good practice if you have to duplicate the data to chart it.
Yes, I confirmed; a go in 2.3, no-go in 3.0.
Jerry
I assumed (bad me, bad me) that the data should be in the same table.
In my opinion, it's not good practice if you have to duplicate the data to chart it.
I'm confused by this. Why would you not always to want the data in the same table in order to chart it? That makes it much easier to "audit" the spreadsheet than if you have a chart that's drawing its data from various and sundry places that only the spreadsheet creator knows for sure. And often you want to show the underlying data along with the chart anyway.
SG
Let's say that you have a multiplicity of tables representing performance of distinct related business operations, as we find nice to do in Numbers, rather than have one large table with all the business operations in a jumble. Perhaps each of these business unit tables lists performance metrics by month for that one business. Then you also want to compare B.U. performance with a multi-series chart, having one series from each business unit's dedicated table. There is no good reason to repeat that data in a table with no purpose other than to drive the comparison chart. Some call this The Numbers Way. The Numbers Way is becoming the iOS way, I guess, which for reasons of compatibility is veering toward The Excel Way.
Jerry
Ok, that's an example close to home (In my day job I study companies). I was thinking you might be thinking about really large sets of scientific data or something where repeating the data could bloat the document. Interestingly, consolidating separate worksheets seems more convenient in Excel than consolidating tables in Numbers. Yet the filters and pivot tables are handy too. So you can do it both ways. Have to spend more times with the charts in Numbers 2.3 and 3.0 to see what you guys are talking about.
SG
How to use the scatter chart in Numbers?
