I noticed that if I have data that trends downward a straight line trendline will suddenly create a negative vertical axis. But if my data is only positive, how would I prevent that negative vertical axis from appearing?
yer.xlsx
I noticed that if I have data that trends downward a straight line trendline will suddenly create a negative vertical axis. But if my data is only positive, how would I prevent that negative vertical axis from appearing?
yer.xlsx
double click the axis and FIX the min to 0
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
You would need to fix the minimum vertical scale value to zero
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks