Action: Create and customize (and move) chart as outlined below. Use videos to assist.
4.1 Create a chart
can easily create a chart of data. It is important that you select the
proper cells when creating charts. In this exercise we will create a
chart comparing the expenses between the two offices for the month of
January. 1. Select cells A3-DC7 2. Select Insert Chart. 3. Select the 'Charts' tab and choose 'Column' 4. Keep this window open. In the next lesson, you will 'customize' the chart.
4.2 Customize the chart
1. Click on Customize 2. In the title field, replace 'Chart Title' with January Office Expenses. 3. Scroll to Axis and select 'Horizontal' - and replace title with 'Expenses'. 4. Change to the left vertical axis and replace with 'Monthly Amount in Dollars'
Other settings: Legend- can move and change formatting of text Font - modify font of all chart text Background - change background color Features - depending on the chart type, these options will modify the chart when selected.
When you are finished customizing your chart, click on Insert.
4.3 Move Chart
the chart is inserted into your spreadsheet you can move it by simply
click and drag and you can also resize. If you would like to 'move to
it's own sheet,' click on the arrow in the top right hand corner and
select 'move to own sheet.'
4.1 Create Chart
4.2 Customize Chart
4.3 Move & Chart Options
Allison Mollica, M. Ed
Virtual Instructor; Google Certified Educator, Trainer, Innovator & Administrator
Official partner with AppsEvents as international consultant, speaker and trainer. Contact me directly for training and professional development an/or to schedule a Summit, Cloud Camp or Academy featuring Google for Education. You can also find me in the Google Education Directory.