You can determine how large or small your graph should be.
#GOOGLE DOCS SURVEY MAKE CHARTS HOW TO#
Hold down the mouse or touchpad to drag the box around your graph How to resize a graph in Google Sheets To move your new graph, complete the following steps:Ģ. You can easily change the location and the size of this graph once it was generated. When you create a new graph, it will appear directly in your Google Sheet. How to change the location and size of your graph The box with these words will expand to display more options.
#GOOGLE DOCS SURVEY MAKE CHARTS SERIES#
It will also allow you to add or remove the following:Ī series (more graph lines with different data)Įach of these can be edited by clicking on the corresponding word(s). Horizontal and vertical axis colors and fonts The Customize tab will allow you to change the following:Ĭhart and axis titles (including their fonts and sizes) You can make all major edits from either of these tabs. The “Chart editor” box has two tabs: Setup and Customize. For all other edits, select the “Customize tab.” If you wish to change the chart style or the cells that comprise your chart (or if you wish to add more chart data) you can do so from the Setup tab. You just learned how to set up your chart (and change this chart to any style, including a graph). How to customize your Google Sheets graph (You will learn about this in the next section.) This plain box will become your graph after you customize its look and contents using the Chart editor. A box titled “Chart editor” will also appear next to this box. A new “chart” (that looks like a plain white box) will appear in the Google Sheet. In the box that appears, select “Chart.”įrom the document menu, select “Insert,” then select “Chart.”Ĥ.
From the document menu, select “Insert.”ģ. Select this data you wish to use in your graph.Ģ. Select the data you wish to use in your graph. To generate a graph in Google Sheets, complete the following steps:ġ. Now that you have entered the data you wish to use, you are ready to convert this data into a graph. To do so, type the title in the top of the right-most column before creating your graph. Or, you can also add a title to your graph. (This is the horizontal axis of the graph.) In the second column, enter the information you would like on the X-axis.
(This is the vertical axis of the graph.)Ģ. In the first column, enter the information you would like on the Y-axis. (This is the vertical axis of the graph.) To enter data for a Google Sheet graph, complete the following steps:ġ. How to enter data for a Google Sheet graph In the box that appears, select “Google Sheets.” A new Google Sheets document will appear in the next tab.Ī new Google Sheets document will appear in the next tab. In the box that appears, select “Google Sheets.” A new Google Sheets document will appear in the next tab. To open Google Drive, from your Gmail account, click the nine dots icon and select “Drive.” Note: All source images from a personal Gmail account.ģ. (From your Gmail account, click the nine dots icon and select “Drive.” Or, go to and sign in.) To create a Google Sheet, complete these steps:ġ. Enter the data you will use in your graph How to create a new Google Sheet
0 kommentar(er)
