How To Change Series Name In Google Sheets

Spreadsheets are amazingly powerful tools for creating, storing, manipulating, and analyzing numeric information. However, not everyone tin can look at a cavalcade of numbers and gain insight into the underlying procedure or information that those numbers are abstracted from.

For that reason, spreadsheet programs, including Google Sheets, take included graphical charting functions almost from their very primeval incarnations back in the Lotus one-2-3 days.

Google Sheets, Google's free cloud-based spreadsheet plan, is available to use via desktop or mobile app. Thus, it allows you to create, edit, and collaborate online, anytime, and anywhere. Google Sheets includes charting components that are uncomplicated but quite powerful. This article will bear witness you how to add together charts to your Google Sheets, how to edit the chart legend, and how to edit some other nautical chart features.

Working with charts is relatively elementary. Y'all only need to have a set up of data to refer to, pattern a chart in the built-in charting tool within Sheets, set the legend then it is easily understandable, and insert it into the spreadsheet. You can create your own data to follow this tutorial, or you can create a new canvas and use the used every bit examples.

For the sample chart, nosotros'll apply a simple footling sheet with a listing of a household's expense category and the monthly upkeep for each expense. Create a canvas with two headings, "Expense" and "Monthly", and add together the following information to the sheet:

Adding a Chart to Google Sheets

To create a chart, we first need to specify a information set for the chart to exist based on. Nosotros begin by selecting a information range and working from there. In the example above, the data range is A1 to B7, or 'A1:B7' in spreadsheet notation.

Open the sheet you want to create a chart inside.

Identify the information range y'all want to use and highlight information technology inside the sail. To highlight, click on the first cell, and elevate your cursor to the terminal square you want to embrace. If you lot do non highlight all data, your chart will non exist authentic.

Select Insert from the acme carte and click Chart. The nautical chart editor volition open on the right side of your screen, and the chart will appear on the sail.

The first line of the nautical chart editor is titled "Chart type". Click the dropdown arrow and choose the chart blazon yous want to use. Sheets volition suggest a few nautical chart types that are suited for the type of data y'all've provided, but you tin cull whatever blazon you wish.

You tin can customize the data elements used in the nautical chart; these controls announced below the Chart blazon selection.

Select the Customize tab in the chart editor to run into the formatting controls. Play with these to learn how to modify your chart. The chart will change as you make changes in the dialog.

When yous take finished modifying the chart, click the X in the upper correct of the chart editor.

Drag the chart to where y'all want it in your Sheet.

Deciding Which Chart Type to Use

Different chart types lend themselves well to displaying unlike data types. Not all chart types will piece of work with all data, so it may be a example of experimenting as you lot go on. The chart editor has a suggestions section which indicates the nautical chart type that the software thinks would be advisable, and yous can commencement from in that location if you really don't know what kind of chart to deploy.

Each type of standard chart has an associated type of information that it is best-suited for displaying, depending on what the visualization is intended to achieve. For example, in the instance of our monthly household expenses, a pie chart is a very powerful mode to demonstrate that our mortgage payment is dominating our monthly expenses because it makes that visual element very big on the sheet.

Edit the chart legend in Google Sheets

Once you've created a chart, it'south likely that you lot'll want to alter the fable. The nautical chart legend is the colored box and text that tells the reader what each color on the nautical chart represents. On the current nautical chart, it is labeled "Monthly". Google Sheets does its best to effigy out a characterization by default, but it oftentimes ends upwards existence something helpful similar "Monthly" – technically accurate, but not very illuminating to anyone looking at the chart.

Editing the nautical chart legend in Google Sheets is washed from within the chart creation window or from within the sheet. One time you've created your chart, you tin bring back the chart editor by right-clicking anywhere on the chart itself and selecting any carte du jour item; this will open the chart editor and accept you to the specific editing area. Y'all can edit the legend in a number of ways. You tin can alter the font, font size, formatting, and text color of the legend.

Right-click the chart and select Legend.
On the right-hand side of the screen, you can make changes to your chart fable'southward position, font type, size, and color.
The chart will update as you make changes inside the editor.

There are several options available for your Sheets legend that include the font, size, and position. Play around with the available features to see which ones piece of work best for y'all.

Changing the legend text in Google Sheets

I feature that many users wish they could have is the ability to change the text displayed for the fable. On our example sheet, for case, the legend "Monthly" isn't really all that useful or descriptive. The but way to alter the fable text is to rename the data column, and the fable volition also change.

For example, nosotros could replace the "Monthly" text in column A2 with "June 2018", or "Estimated Monthly Amount". The chart would then evidence that text instead.

Editing other nautical chart elements

There are many chart elements that you tin can edit within Google Sheets. The easiest way to access nautical chart settings is to right-click inside the chart to pull up the chart editing context menu.

Nether "Chart surface area" you can choose between resizing the chart area (which lets y'all increment or decrease the size of the chart display within the nautical chart frame) or fitting the chart expanse to the bachelor chart frame. (You can change the chart frame past clicking anywhere within the chart, then clicking and dragging on the resizing frame.)

Almost of the elements on the context card simply take you to the advisable section of the Chart Editor, but it'south a very useful shortcut for the commonly selected tasks. Using the context menu, you can change the chart way, change the nautical chart and axis titles and subtitles, choose which data series the nautical chart displays, alter the legend, change the labels on the X and Y axis, fix the filigree lines, or reset the data range the chart draws from.

How to Create a Nautical chart on Google Sheets App on the Mobile App

Google Sheets can also be accessed through smartphones, which is very convenient every bit yous can create and view spreadsheets even when you lot are out and well-nigh. This is how to create a Google Sheets chart using an Android, but the instructions are the aforementioned if you're using iOS.

Open Google Sheets.

Tap the + button at the bottom right side of the screen and select New Spreadsheet.

Enter the data you want to reflect on the chart.

Then, highlight the data that yous want to include in the chart past tapping the showtime cell and dragging the bottom blue dot to the cell of the terminal data entry.

Click the + button at the top correct of the screen. It will open the Insert carte du jour at the bottom of the screen. Side by side, tap on Chart.

You can so choose which chart type you desire to employ, edit the fable, championship, and color.