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

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

  




 

 

Microsoft Office to OpenOffice Migration Guide
Previous Page Home Next Page

Charts

types that Excel provides that Calc does not:

  • Bar of pie converts to a 2D - columns - normal

  • Pie of pie converts to a 2D - columns - normal

  • Radar filled converts to line radar

  • Radar with markers–converts to 2D–net–normal but counter clockwise rather than Excel’s clockwise

  • Bubble charts convert to XY charts

  • Surface Charts convert to Deep 3D bar charts

Other charting issues include:

  • Charts are slower to update in Calc than in Excel.

  • There are fewer axis options, such as no option for having an inverted y axis (negative at top towards positive at bottom).

  • The data must be contiguous, with the labels in the first row or column.

  • To change the range, click on the border of the chart so that it is selected (green selection points) > Right Click > Modify Data Range...

Microsoft Office to OpenOffice Migration Guide
Previous Page Home Next Page


 
 
  Published under the terms of the GNU General Public License Design by Interspire