I made a chart with trend lines. The trend lines both start from the middle of green bar and yellow bar. I want to change them to start from the middle of blue bar and green bar.*How to do this? Thank you.
I have attached the data.
chart.png
I made a chart with trend lines. The trend lines both start from the middle of green bar and yellow bar. I want to change them to start from the middle of blue bar and green bar.*How to do this? Thank you.
I have attached the data.
chart.png
Last edited by qzqzjcjp; 04-22-2015 at 07:35 PM.
Hello,
By default a trendline starts in the center of the first data set, but you can tweak it a bit.
Format the trendlines and enter a number in the Backwards forecast setting. A value of 0.2 should do the trick.
cheers, teylyn
WOW, it works!!! Thank you very much! You are awesome!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks