To insert a chart into the speadsheet,
The Type & Data tab allows you to select the chart type as well as the data you wish to use to create a chart.
Note: for Column, Line, Pie, or Bar charts, a 3D format is also available.
The Layout tab allows you to change the layout of chart elements.
Note: the Lines and Markers options are available for Line charts and XY (Scatter) charts only.
Note: the Axis Settings and Gridlines sections will be disabled for Pie charts since charts of this type have no axes and gridlines.
Note: the Vertical/Horizontal Axis tabs will be disabled for Pie charts since charts of this type have no axes.
The Vertical Axis tab allows you to change the parameters of the vertical axis also referred to as the values axis or y-axis which displays numeric values. Note that the vertical axis will be the category axis which displays text labels for the Bar charts, therefore in this case the Vertical Axis tab options will correspond to the ones described in the next section. For the XY (Scatter) charts, both axes are value axes.
The Horizontal Axis tab allows you to change the parameters of the horizontal axis also referred to as the categories axis or x-axis which displays text labels. Note that the horizontal axis will be the value axis which displays numeric values for the Bar charts, therefore in this case the Horizontal Axis tab options will correspond to the ones described in the previous section. For the XY (Scatter) charts, both axes are value axes.
To edit the chart Title, select the default text with the mouse and type in your own one instead.
To change the font formatting within text elements, such as the chart title, axes titles, legend entries, data labels etc., select the necessary text element by left-clicking it. Then use icons on the top toolbar to change the font type, style, size, or color.
To delete a chart element, select it by left-clicking and press the Delete key on the keyboard.
You can also rotate 3D charts using the mouse. Left-click within the plot area and hold the mouse button until a blue dashed box appears. Drag the cursor without releasing the mouse button to change the 3D chart orientation.
To change the inserted chart type,
The selected chart type and style will be changed. If you need to edit the data used to create the chart,
When the chart is selected, the Shape Settings icon is also available on the right, since a shape is used as a background for the chart. You can click this icon to open the Shape Settings tab at the right sidebar and adjust the shape Fill and Stroke. Note that you cannot change the shape type.
To delete the inserted chart, click it and press the Delete key.
Sparkline is a little chart that fits in one cell. Sparklines can be useful if you want to visually represent information for each row or column in large data sets. This makes it easier to show trends in multiple data series.
If your spreadsheet contains existing sparklines created using some other application, you can change sparkline properties. To do that, select the cell that contains a sparkline with the mouse and click the Chart Settings icon at the right sidebar. If the selected sparkline is included into a sparkline group, the changes will be applied to all sparklines in the group.
Click the Show advanced settings link situated at the right-side panel to open the Sparkline - Advanced Settings window.
The Type & Data tab allows you to change the sparkline Type and Style as well as specify the Hidden and Empty cells display settings:
The Axis Options tab allows you to specify the following Horizontal/Vertical Axis parameters:
Please note that AVS4YOU programs do not allow you to copy protected material. You may use this software in copying material in which you own the copyright or have obtained permission to copy from the copyright owner.
AVS4YOU is a registered trademark of Online Media Technologies, Ltd., UK. Intel and Core 2 Duo are registered trademarks of Intel Corporation. AMD and Athlon X2 are registered trademarks of Advanced Micro Devices, Inc. Windows 10/8.1/8/7/XP/2003/Vista are registered trademarks of Microsoft Corporation. All other trademarks are the property of their respective owners.