Forum Discussion
Trendline on excel graph
Hi everyone, Sorry I am not great at excel... I need to put a trendline on this graph but the line goes below the x-axis - how do I stop this (see attachment)? There are no values in the negativ...
Hello,
maybe you're using the wrong type of trendline. Which one did you apply? I created a chart with your columns, but I cannot get your trendline to show.
What trend do you want to show? This is a histogram already, so a trendline does not really make sense.
Thank you for your reply.
I need to create a bell-like curve on it so I used the polynomial. I can use the moving average one as well but then the line does not look smooth.
I need the curve to show that the data has all shifted towards the right (positive values).
Many thanks,
Abi