Forum Discussion

HermanTeuling's avatar
HermanTeuling
Copper Contributor
Aug 27, 2020

Trendline in Excel sometimes not available

In some graph the option insert Trend line is not available. Somebody knows what the reason can be?   Thanks. Herman
Excel
office 365
HansVogelaar's avatar
HansVogelaar
MVP

aylascholdz 

Click anywhere in the chart.

On the Design tab of the ribbon, under Chart Tools, click Add Chart Element.

Can you insert a trendline from the dropdown menu?

 

 

PEpstein's avatar
PEpstein
Copper Contributor
Jan 19, 2023

HansVogelaar  I have the trend line added in some of my graphs and now the option to add it has a large red "X"

 

 

  • PEpstein's avatar
    PEpstein
    Copper Contributor
    Jan 19, 2023
    So...discovery answering my own question. You need to pay closer attention, Peter, the X none syntax is not what you wanted, you want "moving average" so select it and it displays properly. Then go into the side bar that pos up and dress it up a bit for your presentation!