Charts tutorials

Create a new chart

Insert a new chart by dragging into position

Move or resize chart by mouse dragging

Modify chart elements

Select chart elements using Shift and Ctrl

Left click to access formatting options, and right click to add/remove elements to the chart

Edit data sheet

Open data sheet and edit the data

Paste data from Excel to update the chart

Link a chart to data in Excel

Refresh data in linked chart and break Excel link

Format Y-axis

Add a y-axis to a chart

Add a 2nd y-axis to a combination chart (bar/line)

Control which axis series are plotted against on a chart with two y-axes

Format an axis by left click selection

Change the number format on the y-axis

Adjust axis scale and tick mark spacing

Add an axis break to the chart

Format X-axis

Format the X-axis by left click selection

Adjust the gap in between columns of the chart

Add a category gap (space) in between columns

Edit labels on the chart and revert to original

Format data series

Remove, add and move segment labels

Remove, add, and move total labels

Change number format of segment or total labels

Change the label content of the data series

Format fill and outline of series

Add series CAGRs

Create and remove ‘Other’ series

Hide and unhide series

Add decorators

Add CAGRs to chart and move between columns

Add total and level differences

Change content shown in decorators

Add, position, and format a value line

Add and format connectors between series

Add legend or series names

Add legends to a chart

Move and resize legend

Format the legend

Add series labels to a chart

Move series labels and place as you wish

Change chart layout and theme

Save an Ampler Chart Layout to reuse later

Apply an Ampler Chart Layout to a chart

Save and edit colors of a chart theme

Apply a theme to a chart

Set default layout and theme for Ampler Charts

Change chart or series types

Change to a different chart type

Change a series to a different type

Convert other charts into Ampler Charts