Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Trendline in Excel sometimes not available

Copper Contributor

In some graph the option insert Trend line is not available.

Somebody knows what the reason can be?

 

Thanks.

Herman

15 Replies

@HermanTeuling 

It depends on the chart type. What is the chart type you use?

best response confirmed by HermanTeuling (Copper Contributor)
Solution

3D gegroepeerde kolom @Hans Vogelaar 

I found it! Thanks 3D can not have a trend line @Hans Vogelaar 

@HermanTeuling In my office the trend line is not showing, is there anything related to your question?

@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?

 

S0382.png

The probleem is solved, thanks

@HermanTeuling 

I replied to @aylascholdz who posted a followup question.

when I click "add chart element", "trendline' is greyed out.

@paulatho_ 

What is the chart type of your chart?

@paulatho_ 

Make sure that it is a clustered line chart and not a stacked line chart.

If it already is a clustered line chart: could you attach a copy of the workbook without sensitive data?

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

 

PEpstein_0-1674153161399.png

 

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!
1 best response

Accepted Solutions
best response confirmed by HermanTeuling (Copper Contributor)