SOLVED

Trendline in Excel sometimes not available

New Contributor

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

Somebody knows what the reason can be?

 

Thanks.

Herman

12 Replies

@HermanTeuling 

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

best response confirmed by HermanTeuling (New 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?