Trend Line to Column Chart

[Cian_MRO]

Hi,

I'm trying to use the below to create a straight trend line on my column chart. 

It doesn't seem to be doing what I'm after, any pointers?

I know there is other styles of graph that can display a trend line but I really need it on this specific style of graph.

thanks 

 

 

[Anonymous · Accepted solution]

Hi @Cian_MRO ,

Maybe you can use clustered column chart to create visual and use trend line.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Cian_MRO]

Thanks for the reply, unfortunately I think this only works for numerical or individual dates, if using date hierarchy like I am to group data by month/year, it doesnt give the option of a trend line. Thanks