Trendline in Excel sometimes not available

[HermanTeuling]

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

Somebody knows what the reason can be?

Thanks.

Herman

[#2]

@HermanTeuling 

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

[#3 · Accepted solution]

3D gegroepeerde kolom @Hans Vogelaar 

[#4]

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

[#5]

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

[#6]

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

 

[#7]

The probleem is solved, thanks

[#8]

@HermanTeuling 

I replied to @aylascholdz who posted a followup question.

[#9]

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

[#10]

@paulatho_ 

What is the chart type of your chart?

[#11]

Line

[#12]

Line

[#13]

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