Select cells. Next, select the cells within your sheet that you want to use to create your chart.

Double-check to make sure that the data you use for your chart is accurate. For example, if you use a spreadsheet to record sales, you might put store names in the cells along the left (e.g., column A) and place month names along the top (e.g., row 1). Typically, the furthest left column and uppermost row serve to label your data in some way. Enter data. In most cases, you'll enter data and labels in your spreadsheet in columns and rows.Then follow the steps below to create a chart with Google Sheets. To get started, go to Google Sheets in Chrome, then either open an existing sheet or type to create a new spreadsheet. Currently, the Google Sheets apps that you may install on Android or Apple devices offer a smaller number of charts (17, compared to 32 on the web), as well as far fewer chart display customizations than available in Google Sheets on the web. SEE: Google Sheets: Tips and tricks (TechRepublic download)įor the greatest control over charts in Google Sheets, you'll want to create and edit your charts with Google Sheets in Chrome on a laptop or desktop. You can work with other people each step of the way to enter data, select the cells to chart, experiment with different chart types, and refine the display to optimize chart readability. A well-constructed chart may make it possible for a viewer to comprehend a trend, compare quantities, or understand relationships in the data displayed.Īs a collaborative, cloud-based app, Google Sheets lets you create charts collaboratively. For many, a glance at a graph can convey meaning in a way that a look at a long list of numbers cannot.

Histogram maker google sheets