Apple Intelligence now features Image Playground, Genmoji, Writing Tools enhancements, seamless support for ChatGPT, and visual intelligence.

Apple Intelligence has also begun language expansion with localized English support for Australia, Canada, Ireland, New Zealand, South Africa, and the U.K. Learn more >

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.

Numbers - Chart Trend Lines

I have created a 2D Bar chart graph, in the Numbers app on my MacBook Pro, using two data sets. I am trying to add a trend line but when I select the graph data and go to the Series Tab to get the Trendline dropdown - it is not shown. I simply get the Data, Value Labels, and Error Bars options.


How do you get trendlines?


Thanks

Posted on May 3, 2020 4:28 AM

Reply
4 replies

May 4, 2020 9:15 AM in response to Yellowbox

Hi Ian


Thank you for your help. This does not appear to solve the problem.


I am using a 2D Stacked Column graph format, in Numbers 10.0, and there is a header row and column. I am using two columns of data. I have done as you suggest and highlighted the graph data column, as I did previously, but it still does not offer me a Trend line.


Any other suggestions?


Many thanks

John




May 5, 2020 12:51 AM in response to Yellowbox

Hi

Thank you for your follow-up.


i have created a column with a 12 month moving average, which is what I am looking for, which works with the line graphs.


From what I can see it cannot be used on the 2D Stacked Columns.


I have though of doing a second line graph to the same scale and simply overlaying it. Not the purest of solutions but OK I guess.


Many thanks for your input.

regards - stay safe

John

Numbers - Chart Trend Lines

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