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...
