Create a Chart in Excel of the height of famous mountains. The data is here.
Open Excel |
|
In cell A1 type Mountains. |
![]() |
Under Mountains, type the following data: |
![]() |
Under Height in Feet, type the following data: |
![]() |
Now make a graph of the results. |
|
Highlight the cells you want in your graph. Include headings. |
![]() |
Click on the Chart Wizard. |
|
Click to select a chart type- Column. |
![]() |
Make sure the Titles tab is selected. Under Chart title type "Heights of Famous Mountains." |
![]() |
Click the button beside As New Sheet. Click Finish. |
![]() |
When your graph is finished, you probably won't be able to see all the Mountain names. To change this: Double click on the names. Click the Alignment tab. Click on the square that stands for the angle you want your text to have. Click OK. |
![]() |
To change the bar colors double click on it. |
![]() |
Home | About Us | Our Services | Software | Spreadsheets Library | Excel Tutorials | Useful Links | Site Map | Contact Us
Unless otherwise stated, all images and text
Spreadsheet123
Visit our busy book shop, were you can find latest books for beginners as well as advanced excel users.
Spreadsheet 123 Spreadsheet Software Development
See Spreadsheets for:
a.Hotel
Management b.Personal
Budget
c.Corporate
Finance d.Rating
Calculation e.Real
Estate and Mortgage
f.Web Calc