Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Before you edit: You can change the points and bars of bar, column, line, scatter, and certain types of combo charts. On your computer, open a spreadsheet in Google Sheets. On the chart, right click the bar or point. Click Format Data Point. Make your changes. Tip: You can add borders to bars and columns, but not to points or lines.

This help content & information General Help Center experience. Search. Clear search

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Use a 100% stacked bar chart when you want to show the relationship between individual items and the whole in a single bar, and the cumulative total isn’t important. Learn how to add and edit a chart. How to format your data. Format row and column data like a bar chart. You need at least 2 data series. Example Sales per month

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Rows: Each row represents a different bar on the chart. If you enter 2 or more columns of numeric data, you can choose to see the data sequentially or stack it. Tip : If the chart doesn’t show the data on the axis you want, learn how to switch rows and columns .

Make a chart or graph. On your iPhone or iPad, open a spreadsheet in the Google Sheets app. Select the cells you want to include in your chart. Tap Insert Chart. Optional: To choose a different chart, tap Type. Then, choose an option. When you’re done, tap Done .

This help content & information General Help Center experience. Search. Clear search

You can add a label that shows the sum of the stacked data in a bar, column, or area chart. Learn more about types of charts. On your computer, open a spreadsheet in Google Sheets. Double-click the chart you want to change. At the right, click Customize Series. Optional: Next to "Apply to," choose the data series you want to add a label to.