The Naturally Spreadsheets blog

Business-focused Excel tips absolutely free from business trainers, not IT people. Learn Excel skills which you can apply in real life with our regular updates and downloadable examples.

Thursday, 13 March 2014

Formatting a chart axis

By Neil Shorney, Director, Naturally Sales Ltd.


The problem: you're creating a chart, and you don't want the axis to start from zero.
 

The solution: left-click on the axis you want to modify, then right-click and choose "Format axis". You'll then see a box to state the maximum value of the axis, and one to set the minimum value, and can show exactly what you want to!
Posted by Unknown at 14:43 No comments:
Newer Posts Older Posts Home
View mobile version
Subscribe to: Comments (Atom)

Blog Archive

  • ►  2020 (4)
    • ►  March (2)
    • ►  January (2)
  • ►  2019 (4)
    • ►  December (2)
    • ►  November (1)
    • ►  October (1)
  • ►  2018 (4)
    • ►  May (2)
    • ►  April (1)
    • ►  January (1)
  • ►  2017 (5)
    • ►  November (1)
    • ►  September (1)
    • ►  August (1)
    • ►  July (1)
    • ►  June (1)
  • ►  2016 (3)
    • ►  April (1)
    • ►  February (2)
  • ►  2015 (2)
    • ►  October (2)
  • ▼  2014 (13)
    • ►  September (1)
    • ►  August (2)
    • ►  July (1)
    • ►  June (2)
    • ►  May (1)
    • ►  April (1)
    • ▼  March (1)
      • Formatting a chart axis
    • ►  February (1)
    • ►  January (3)
  • ►  2013 (32)
    • ►  December (2)
    • ►  November (3)
    • ►  September (4)
    • ►  August (3)
    • ►  July (3)
    • ►  June (8)
    • ►  May (3)
    • ►  April (6)

Search This Blog

­© Naturally Sales Ltd. www.nsales.co.uk. Awesome Inc. theme. Theme images by Petrovich9. Powered by Blogger.