Change a series color
Left-click a legend series, open Fill, and pick a color.
WatchHelp center.
Editor how-tos for charts that stay alive everywhere, plus Google Slides setup, Sheets sync, and surface-specific guides.
Search titles, summaries, and categories in the active surface
Series style
Labels
Add a chart title
Right-click the chart background and show the main title.
WatchShow data labels
Right-click the chart and show all data labels.
WatchShow column labels
Right-click the category axis and show all column labels.
WatchShow total labels
Right-click the chart and show all total labels.
WatchHide or show total labels
Right-click the chart to hide all total labels, or show them again.
WatchShow or hide the legend
Right-click the chart and show or hide the legend.
WatchReposition the legend
Left-click the legend chrome, then drag it into clear space away from the series.
WatchReposition a data label
Left-click a crowded data label, then drag it into clear space.
WatchChange number format
Left-click a data label and pick a format from Absolute format.
WatchAdd a number prefix and postfix
Left-click a data label, then type a prefix and postfix pattern in Absolute format.
WatchAnnotations
Add a text annotation
Right-click the chart, add a text box, then drag it into clear space.
WatchAdd a CAGR arrow
Right-click the chart, add a CAGR arrow, stretch it across the period, then lift it clear of the bars.
WatchAdd a difference arrow
Right-click the chart, add a difference arrow, drag the end to the comparison column, then lift it clear of the bars.
WatchAdd a level line
Right-click the chart, add a level line, then drag it to the value you want to mark.
WatchFormat an arrow
Left-click an arrow, thicken the line style, then change its color.
WatchShow a difference arrow as absolute
Left-click a difference arrow, set Display to an absolute value, then reverse the arrow direction.
WatchStructure
Switch stacked and clustered bars
Use the chart type control to switch between stacked and clustered bars.
WatchSwitch to a Marimekko chart
Use the chart type control to switch the chart to Marimekko.
WatchPut a series on a secondary axis
Left-click a combo line series, set Right axis, then drag the top of the right axis down until the line sits above the bars.
WatchChange axis scale and interval
Left-click the value axis, drag the top handle to set the scale, then drag the interval handle for tick spacing.
WatchFlip chart orientation
Left-click Horizontal bars in the Orientation control to switch vertical bars to horizontal.
WatchReverse series order
Left-click a segment and switch Segment order to Reversed sheet order.
WatchAdd or reposition an axis break
Right-click the chart, add a break, then drag it into another segment of the tall column.
WatchFormat an axis break
Left-click an axis break, change Break Style, then set Coverage.
WatchSet waterfall column type
Left-click a waterfall column and set it to Start, Contribution, or Total.
WatchNo articles match your search in this surface. Try different words or contact us.
Can't find what you're looking for? Contact us