charts

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

Insert a new chart by dragging into position

Link a chart to data in Excel

Refresh data in linked chart and break Excel link

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

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 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 legends to a chart

Move and resize legend