Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

OpenOffice Calc User Guide
Previous Page Home Next Page

Changing axes scales

The numbers on the y-axis of our example chart are cluttering things up and it makes sense to start the y-axis at zero percent cloud cover. To do this:

  1. Right-click with the cursor inside the graph and select Edit (See Figure 59).You can also double-click on the graph to place it in Edit mode.

Frame23

  1. From the menu bar, select Format > Axis> Y Axis and select the Scale tab.

  2. Set the Minimum value to 0 and Major Interval to 5. Leave the other settings as they are.

    These changes produce the graph shown in Figure 60. This is a bit better, but the scale on the x-axis could be improved.

Frame24

  1. Again right-click in the chart and select Edit. Then from the menu bar, select Format > Axis > X Axis. Leave the Minimum value at 10 km/hr but reset the maximum value to 40 km/hr and the major interval to 5.

Figure 61 looks better and is much less cluttered.

Frame25

We could have reset the Minimum value to 0 as we did with the y-axis but we would have ended up with a lot of unused space on the left side of the graph. Try it and see what you think. Graphs do not need to start from a (0,0) origin.

OpenOffice Calc User Guide
Previous Page Home Next Page

 
 
  Published under the terms of the Open Publication License Design by Interspire