Thursday December 15 1947 "It was the best of times it was the worst of times..." [Tale of Two Cities, by Charles Dickens, referring to the time of the French Revolution and during the midst of Dr. Neuage's Excel class]

http://www.wmburgweb.com/Resources/Lesson/charts.htm

 Exercise one.

Angled text

Exercise two.

Add an angled border to an empty cell

Exercise three.

Exercise four

Exercise five.

Exercise one

Today we will begin adding figures from different columns to our equations. For example, I do this for a class I teach at University at Albany - notice it all begins with +SUM(:

I have copied the headlines for you if you did not get it done during the last class. See here mate! If you have already filled in your spreadsheet with the data then you just need to do the angled text thing. If you have not come back to this and put in the data for example the foods you ate. We followed these steps:

1. Burger King site

2. Choose our menu

3. Pick your items

4. Click the term 'Nutritional Information'

5. put you data into your spreadsheet PICK AT LEAST FIVE ITEMS (below is one item)

Angled text

As you should well know (because I have said/demonstrated/thought-to-say, at least a million and fifty times), many times the label at the top of a column is much wider than the data stored in it. For example, the names of your pets have more than 70 letters for each terrifying pet and it looks really budget shrinking and wrapping the name in your Excel spreadsheet though of course it would be even more budget to shrink-wrap your pet. You can use the Wrap text option (Format menu > Cells command > Alignment tab) to make a multiple-word label narrower, but sometimes that is just not good enough. Vertical text is an option, but it can be difficult to read and takes a lot of vertical space. Therefore we will use rotated text and cell borders instead, as shown in the following picture.

You may also want to use that budget cell that generally remains empty in the upper left corner of a table. You can use an angled border to create dual-label corner cells like the one shown in the following picture.

How to apply angled text and borders to impress and amaze your neighbors (be the first on your block to know this little known trick)

1.                  Select the cells you want to format.

2.                  On the Format menu, click Cells.

3.                  On the Border tab, apply vertical borders to the left, right, and middle of the range.

4.                  On the Alignment tab, in the Orientation box, click a degree point, or drag the indicator to the angle you want.

Select a positive angle between 30 and 60 degrees.

5.                  Under Text alignment, in the Horizontal list box, click Center, and then click OK.

Excel rotates the left and right borders along with the text.

6.                  To shrink all the columns to their smallest possible width, select them, point to Column On the Format menu, and then click AutoFit Selection.

You may also want to use that budget cell that generally remains empty in the upper left corner of a table. You can use an angled border to create dual-label corner cells like the one shown in the following picture by following the simple instructions listed below the image of ‘my groovy angles’.

Exercise two

Add an angled border to an empty cell

1.                  Select the cell you want to format, and then type 10 space characters.

2.                  Type the first label, which corresponds to the column labels across the top of the table.

3.                  To create two line breaks in the cell, hold down ALT, and then press ENTER twice.

4.                  Type the second label, which corresponds to the row labels down the left side of the table, and then press ENTER.

5.                  With the cell selected, click Cells on the Format menu.

6.                  On the Border tab, in the Line box under Style, select the line style you want.

7.                  Under Border, click the upper left to lower right angled border button.

8.                  On the Alignment tab, under Text control, select the Wrap Text check box, and then click OK.

Or to cut to the chase put your cursor in the cell you wish to angle > go to > Format > Cells > Border and click on the angle symbol and in the Line > Style box – pick the line that floats-your-boat and the colour that you harmonize with then go to > Alignment > and the rest is history.

Exercise three

Exercise three A. What is the fat content total of your five selected items?

With your spreadsheet opened, you will enter the calories in column C and fat calories in column D. 

To figure out non-fat calories, write a formula to subtract the fat calories from the total calories. (HINT: =C3-D3) remember all formulas must begin with =SUM(

then using Insert > Function add it all together

Exercise three B.What is the percentage of calories from fat of your five selected items?

To figure out the percentage of calories from fat, divide fat calories by calories. Format the cells in column E for percentage. (HINT: =D2/C2)

Exercise three C. What is the total calories, total fat calories, and total non-fat calories of your five selected items?

To figure out total calories, total fat calories, and total non-fat calories,  you can use the AutoSum button or write a formula.  To figure out the total percentage of fat, divide total calories by total fat calories.

Exercise four

Exercise five

We are going to make some simple charts.

At the end of this you will have a pie-chart and a column chart of your menu choices.

You'll be making three charts to go along with your spreadsheet.  Save them as part of your spreadsheet.  When you finish the spreadsheet and chart, answer the questions on the handout.  Spreadsheets and Charts

After you have created the spreadsheet regarding your meal, you are ready to create your chart.

1. Highlight all the cells containing the data you want in your chart. You should also include the data labels.
2. Choose Insert > Chart from the menu.
3. Click Column to select the type of chart you want to create.
4. In the Chart Sub-type box, choose the Clustered Column icon to select the chart sub-type.

7. Click Next.
8. To place the product names on the x-axis, select the Columns radio button.
9. Click Next.
10. Type Menu in the Chart Title field. Menu will appear as the title of your chart.
11. Type Foods in the Category (X) Axis field. Products will appear as your x-axis title.
12. Type Nutrition in the Value (Y) Axis field.  Nutrition will appear as your y-axis title.
13. Choose the Data Labels tab.
14. Select Value in the Labels Contain Frame to display the data labels as values.
15. Choose the Data Table tab.
16. Select Show Data Table. The data table will appear below your chart.
17. Click Next.
18. Choose As Object In Sheet1 to make your chart an embedded object and part of the worksheet.
19. Click Finish
20. Your chart will appear on the spreadsheet.

Changing the Size and Position of a Chart

When you select a chart, handles appear on the right and left sides, the top and bottom, and the corners of the chart. You can drag the handles on the top and bottom of the chart to increase or decrease the height of the chart. You can drag the handles on the left and right sides of the chart to increase or decrease the width of the chart. You can drag the handles on the corners of the chart to increase or decrease the size of the chart proportionally.

You can change the position of a chart by clicking on the chart and dragging

1. Use the handles to adjust the size of your chart.
2. Click the chart and drag to position the chart under the data.

Modify Your Chart

You can modify your chart by using the Chart toolbar. If the Chart toolbar is not already available, choose View > Toolbars > Chart from the menu.

Chart Toolbar

To change the data area font size:

1. Click the down arrow on the Chart toolbar. A drop-down menu opens.
2. Choose Data Table from the drop-down menu.

3. Click the Options icon . Choose the Font tab.
4. In the Size box, type 8.
5. Click OK. Your font size is now 8.

To change the angle of the data labels:

1. Click the down arrow on the Chart toolbar. A drop-down menu opens.

2. Choose "Region 1" Data Labels from the drop-down menu.

3. Click the Angle Counter Clockwise icon . The Region 1 Data Labels are angled counter-clockwise.

4. Repeat this process for Regions 2 and 3.

To change the font size of the Region data labels:

1. Click the down arrow on the Chart toolbar. A drop-down menu opens.
2. Choose "Region 1" Data Labels from the drop-down menu.
3. Click the Options icon. Choose the Font tab.
4. In the Size box, type 6.
5. Click OK. Your font size is now 6.
6. Repeat this process for Region 2 and 3.

You can also make changes by double-clicking on the item you want to change.

To change the chart scale:

1. Double-click on the scale. The Format Axis dialog box opens.

2. Choose the Scale tab.
3. Type 400 in the Major Unit field.
4. Click OK. Your chart is now scaled in units of 400.

Sample Charts   Create this column chart by selecting the data in columns A, B, and C. or whatever columns you had them in.     Create this chart by selecting the fat/non-fat calories for one of the items on your menu.  You'll need to select the labels in cells C1 and D1 or whatever other columns you used and then the calories.  Don't forget to hold down the Control key to select data that isn't right beside each other.  Be sure to label your data and include the percentages. Don't forget a title! Create this chart by selecting your total fat and non-fat calories for the meal found in cells C6 and D6.  You'll need to select the labels in cells C1 and D1 and then the calories.   Don't forge to hold down the Control key to select data that isn't right beside each other.  Be sure to label your data and include the percentages.  Don't forget a title!