Trendline - Cluster column chart with 2 axes

[Apprentice]

Hi everyone,

I'm trying to include a trendline for a cluster column chart which is plotted on 2 axes and also for 2 separate sets of data. Is it possible to do so? Attached is the chart that I've made in which trendline is required. Can someone help please?

 

[Apprentice]

Sorry the attachment didn't appear in the last message

 

[vletm]

Could You upload an Excel-file?

 

[Apprentice]

Please find the excel attached

 

[vletm]

Eg something like this ...
and for those which has data.

 

[Apprentice]

Thanks for this. Actually i wanted 2 trendlines in the same graph. The data for TP1 and TP2 are different so would need 2 separate trendlines

 

[vletm]

Apprentice
Thanks for this. Actually i wanted 2 trendlines in the same graph.
... hmm?
For my eyes, both graphs have two trendlines ...

 

[Apprentice]

I meant to say 2 trendlines for each so that makes 4 lines in one graph. For eg. 1 trendline for normal traffic and 1 for overload for TP1. Similarly for TP2

 

[vletm]

If You meant something then You should do something ...
As long as those datas of both charts are as those are now then those are Your trendlines.