Use a table chart to turn a spreadsheet table into a chart that can be sorted and paged.
Learn how to add & edit a chart .
How to format your data Columns : Enter numeric data or text. Data within each column must be the same type.
Tip : To sort the table, click on a column header in the chart.
Examples Employee salaries
Name Salary Full time employee Ashley $60,000 ✔ Tom $20,000 ✗ James $50,000 ✔ Michelle $45,000 ✔ Susan $55,000 ✔ John $15,000 ✗ Kathleen $25,000 ✗ Darlene $70,000 ✔ Max $30,000 ✗ Allison $70,000 ✔ Sarah $20,000 ✗ Rachel $25,000 ✗
Make a copy
Annual revenue & net income
Year Revenue Net income 2014 $43,000 $10,500 2015 $56,400 $11,345 2016 $67,988 $12,430 2017 $78,333 $14,000 2018 $94,500 $15,768
Make a copy
Customize a table chart On your computer, open a spreadsheet in Google Sheets . Double-click the chart you want to change. At the right, click Customize Table . Change how the table looks, sort the table, or add pagination. Related articles
Need more help? Try these next steps:
Visit the Learning Center
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.
FAQs
Go to Insert > Chart. Click on the Chart and choose the type of chart or graph you want to use . The chart or graph will automatically be inserted.
How do I edit a table chart in Google Docs? ›
Google Docs
On your Android phone or tablet, open a document. Tap a table. Tap a cell in the row or column you want to change. Tap Format . Tap Table. To change the row and column size, tap the up or down arrows next to "Minimum row height" and "Column width."
How do I use Google chart editor? ›
Make a chart or graph
On your Android phone or tablet, 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. Tap Done .
How do you edit table lines in Google Docs? ›
Google Docs
On your computer, open a document and select cells in a table. Go to Format Table. Table properties. You can also right-click the table and select Table properties. Under "Column" or "Row," enter the width and height you want for all highlighted cells. Click Ok.
How do you use Charts in Google Docs? ›
Go to Insert > Chart. Click on the Chart and choose the type of chart or graph you want to use . The chart or graph will automatically be inserted.
How do I customize a table chart in Google Sheets? ›
Customize a table chart
On your computer, open a spreadsheet in Google Sheets. Double-click the chart you want to change. At the right, click Customize. Table. Change how the table looks, sort the table, or add pagination.
How do I edit a table in a chart? ›
Select the chart. Select Chart Design > Edit Data in Excel . Excel opens and displays the data table for the chart.
How do I use Google Docs editor? ›
On your Android phone or tablet, open a document in the Google Docs app . Tap Edit . To select a word, double-tap it. Move the blue markers to select more text. Start editing. To undo or redo an action, click Undo or Redo .
Does Google have a chart tool? ›
Google Charts provides a perfect way to visualize data on your website.
How do I access graph editor? ›
A graphical representation of interpolation between animation keys that you can modify. To open the Graph Editor: From the main menu bar, select Windows > Animation Editors > Graph Editor .
You can position a table the same way that you position regular text, using the alignment controls.
Click a cell inside the table. Click Format on the menu bar. Select Table. Select Table properties. Click the Table alignment button. Select an alignment option. Click OK.
How do I edit a table line? ›
Add or change a table border
Select the table cells that you want to add a border to (or change the border of). Select the Table Design tab on the ribbon. Select one of the following in the Draw Borders group: ... To apply the color, weight, or line style that you chose in step 2, do one of the following:
How do you edit lines in Google Docs? ›
Use the editing tools
Line, Elbow Connector, Curved Connector or Arrow: Click to start, then drag across the canvas. Curve or Polyline: Click to start, then click at each point you want the line to bend. Double-click or complete the shape to finish. Scribble: Click to start, then drag across the canvas.
How to use Google charts? ›
How to Use Google Chart?
Add a <div> element (with a unique id) in the HTML where you want to display the chart: Add a link to the charts loader: Load the Graph API, and add the function to run when the API is loaded:
How to use chart editor in Google Sheets? ›
The chart editor in Google Sheets allows you to create a line chart directly in your spreadsheet.
Step 1: Open the Google Sheets file. ... Step 2: Select the dataset. ... Step 3: Open the chart editor. ... Step 4: Choose to create a line chart. ... Step 5: Move the line chart to its own sheet (optional) ... Step 6: Customize the chart.
How do I edit a chart design? ›
Click the chart that you want to format. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Chart Styles group, click the chart style that you want to use . Tip: To see all predefined chart styles, click More .
How do I change the format of a table of contents in Google Docs? ›
On your computer, open a Google Doc that contains a table of contents. Click the table of contents. More options. In the panel on the right you can change the format of your table of contents and the heading indents .
How do you edit data in a table? ›
Double-click the table cell. As an alternative, you can right-click the table cell and click Edit Value . Change the contents of the cell and press Enter.
How do I edit a chart in Google forms? ›
Often when you click on a chart, you will see a menu in the top right of the chart. Select the option to edit the chart . You can use the customization menu to make adjustments.
Article information
Author : Roderick King
Last Updated : 2024-09-20T10:55:09+07:00
Views : 5921
Rating : 4 / 5 (51 voted)
Reviews : 90% of readers found this page helpful
Author information
Name : Roderick King
Birthday : 1997-10-09
Address : 3782 Madge Knoll, East Dudley, MA 63913
Phone : +2521695290067
Job : Customer Sales Coordinator
Hobby : Gunsmithing, Embroidery, Parkour, Kitesurfing, Rock climbing, Sand art, Beekeeping
Introduction : My name is Roderick King, I am a cute, splendid, excited, perfect, gentle, funny, vivacious person who loves writing and wants to share my knowledge and understanding with you.
Table.
Table.
