We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Help with Excel
hjb123
Posts: 32,002 Forumite
in Techie Stuff
Wondered if there are any Excel wizard on here
Am busy doing some graphs and wondered if there was any way of the vertical (y) axis not starting at 0 ? On the x axis i have dates and on the vertical numbers. the numbers I am plotting are between 3 and 4 and thought there was maybe a way to get the axis to start at 3 and finish at 4
thanks!
Am busy doing some graphs and wondered if there was any way of the vertical (y) axis not starting at 0 ? On the x axis i have dates and on the vertical numbers. the numbers I am plotting are between 3 and 4 and thought there was maybe a way to get the axis to start at 3 and finish at 4
thanks!
Weight Loss - 102lb
0
Comments
-
There is.
If you display your graph and the right-click on the Y-axis and choose "Format Axis"
You can then enter the minimum, maximum and various other values as necessary.:wall: Flagellation, necrophilia and bestiality - Am I flogging a dead horse? :wall:
Any posts are my opinion and only that. Please read at your own risk.0 -
Hi... If you do the graph as you would normally...
Then
Click on the y-axis and you will get a box up that says "Format Axis"
Click on second tab Scale and you should be able to change it to what you want
Hope that works ok...0 -
thanks you guys, thats greatWeight Loss - 102lb0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 352.5K Banking & Borrowing
- 253.7K Reduce Debt & Boost Income
- 454.5K Spending & Discounts
- 245.5K Work, Benefits & Business
- 601.5K Mortgages, Homes & Bills
- 177.6K Life & Family
- 259.5K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards