This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Charts Charts are dynamic 3 tabs: o Design o Layout o Format In Layout and Format tabs go to drop down where current selection is o You can choose a bunch of options here 1. Bar Graph about Pies To Make chart click anywhere in the data set and go to insert, chart Click “clustered bar” and your chart appears! When you select a chart the data is highlighted Design Tab: o Select Data (pulls up dialog box) o You can chance the title in this window A chart title is a textbox so you can just click it to change it • Or you can do = A1 (pick the cell with the proper title) Layout Tab: o You can edit the legend from here o Can change axis titles here as well You can select the titles on the horizontal axis and can adjust the font and such Layout Tab: o Data Labels options Can do stuff like put percentages on the end of bars o Gridlines If you have data labels they don’t add much To change background color: 1. Click on chart and go to format selection...
View Full Document
- Fall '08
- Bar chart, Layout Tab, chart area