Enter this data in a Google Spreadsheet Simple Pie ChartIn the spreadsheet you have just created, Use the age and Total Users columns only, insert this chart in your spreadsheet change the chart type to 3D Customize the chart: add the Title
Set the Legend to Labeled
remove the data from the Slice
Bar ChartUsing the same spreadsheet, insert a second chart. NOTE: you can move each chart on its own sheet.
Add the Title Horizontal and Left Vertical titles change the color of the bars Chart 3 -Stacked BarThis time you will need to select your data differently - select the age data only,including the word Age.
- From the Start Tab:
- click on Select range ...
- click on Add another range
- select the Male and Female data, including the words, Male and Female
- Press OK
- you may need to use a row as headers
- From the Charts Tab:
- select the Stacked Bar graph
- Use Customize to add the Title
|