Excel – Charts 1

This lesson covers Column, Line, and Bar charts and the three chart tabs in the ribbon.

Instructions:

Read through the set of learning objectives (Summary of Key Points). This is what you should know when you finish the lesson.

Complete every step in the assignment, in the order given. Do not skip steps.

When you have done all of the steps, fill out the Check for Understanding (CFU) form.

 

A completed CFU for every lesson, in-class and homework, is due to be turned in during your next class.  The CFU forms are not to be submitted by email.

 

Where there are differences between software versions, the instructions for Office 2010 are in Black, for the Mac are in green and for 2013 are in blue.

Summary of Key Points:

Create a bar chart.

Select ranges from different areas on the worksheet using the control key.

Use the tools on the Chart Tools Design tab / Chart Elements icon.

Use the tools on the Chart Tools Layout tab.

Right-click methods to format chart objects.

Use the tools on the Chart Tools Format tab.

Add textboxes, clip art, and graphics to charts.

Create a column chart.

Create a line chart.

Section 1 - Overview

 

Elements of the Chart Screen

The picture shows my data range on the left, the column chart in the middle, and three formatting icons on the right. Two tabs for working with charts, Chart Tools, will appear in the ribbon above the chart. 

 

 

The names shown under the Horizontal X-axis are created from the column labels. The range of values shown on the Vertical Y-axis start with zero and go up to the biggest number found in the data.

In this chart, the Legend appears under the chart. It shows the names of each row of data and shows the color used to represent that row in the chart.

Each of the rows of data will appear in the chart with a different color. Each block of color represents a different data point. The Sandwich data appears as the blue part of each column. A set of data points sharing the same color is called a data series. 

 

Formatting icons

 

     Add/Edit Names and Labels

   Add/Edit Colors and Styles

   Add/Edit Chart Elements 

 

 

The Charts Tools Design Tab.

 

 

The Change Colors icon is used to switch the set of colors that are used in the chart.

The Chart Styles icons are used to select a design for your chart.

The Switch Rows/Columns icon is used to reverse the X and Y axis layout of the chart.

The Select Data icon is used to alter the range of data you selected when you created the chart. The dialog box lists each row and column used to create the char. Un-checking a box next to a series name will hide that data and alter the appearance of the chart. If you selected the wrong data when creating your chart, you can select the name of a series and press the Delete icon to remove it.  It is usually easier to start over rather than trying to make corrections through this dialog box.

The Change Chart Type icon is used when you discover used chose the wrong type of chart when you created it.

The Move Chart icon is used to move the chart into a new or different worksheet.

 

Formatting Chart Elements using the right-click method.

If you position your cursor above different parts of the chart, a label will appear, giving you the name of that chart element.  Try it. You can format any element in the chart by right-clicking on it. Select the Format option at the bottom of the menu.  A formatting dialog box for that element will appear to the right of the chart.

 

 

The icons stand for:

Fill & Line                    Special Effects                         Series Options

Line / Border               Shadow/Glow/Edges/3-D        Varies by type of chart.

 

Adding Chart Elements

The Add Chart Element icon on the Chart Tools Design tab gives you a dropdown menu listing items (labels for example) to add or remove from the chart.

In earlier versions of Excel this set of options had its own tab in the ribbon, called Layout.

 

Watch the video starting at 5:35 to see examples of how to use the chart elements options.  https://www.youtube.com/watch?v=KOOGje8W3P0            Time = 9:19

 

SECTION 2 BUILDING CHARTS

  1. Open Excel 
  1. Download and save the file

http://bus91L.altervista.org/Data/2013Data.xlsx

  1. Open the file and enable editing.
  1. Select the Sales worksheet. It contains the information we will base our charts on.

 

Java Juice Café - Sales Forecast

Prepared by:  Your Name

 

 

 

 

 

 

 

January

February

March

April

May

June

Total

Food Sales

 

 

 

 

 

 

 

Sandwiches

$41,500

$42,500

$43,500

$44,500

$45,500

$46,500

$264,000

Soups

$19,000

$20,710

$22,574

$24,606

$26,820

$29,234

$142,943

Desserts

$22,000

$23,100

$24,255

$25,468

$26,741

$28,078

$149,642

Total Food Sales

$82,500

$86,310

$90,329

$94,573

$99,061

$103,812

$556,585

 

 

 

 

 

 

 

 

Beverage Sales

 

 

 

 

 

 

 

Coffee

$34,000

$35,020

$36,071

$37,153

$38,267

$39,415

$219,926

Tea

$15,000

$15,000

$15,000

$15,000

$15,000

$15,000

$90,000

Beer/Wine

$12,000

$11,640

$11,291

$10,952

$10,624

$10,305

$66,811

Juice

$5,000

$5,750

$6,613

$7,604

$8,745

$10,057

$43,769

Soft Drinks

$7,000

$8,360

$9,720

$11,080

$12,440

$13,800

$62,400

Total Beverage Sales

$73,000

$75,770

$78,694

$81,789

$85,076

$88,577

$482,906

 

 

 

 

 

 

 

 

Ingredient Costs

 

 

 

 

 

 

 

Food Costs

$24,750

$25,893

$27,099

$28,372

$29,718

$31,144

$166,976

Beverage Costs

$10,950

$11,366

$11,804

$12,268

$12,761

$13,287

$72,436

 

 

 

 

 

 

 

 

Net Revenue

$119,800

$124,822

$130,120

$135,722

$141,657

$147,959

$800,080

Chart One: 2-D Stacked Bar Chart

We will start by building a bar chart showing monthly food sales by category for six months.

Selecting data 

  1. Mouse over and select the numbers in the range B5 to G7. From the insert tab click on the Bar chart icon [ALT  N  B]. In Office 2013/16 the shortcut is [ALT  N  C]. Mouse over the Bar icons to find the chart type labeled Stacked Bar. Click on this choice. The chart will appear in the same worksheet as the data. 

For the MAC: After selecting the range B5-G7, click on the Charts (located on the ribbon bar). Under the chart type, there is an icon called “Bars”. Select “bars” and a drop box will appear and select stacked bar.

This chart is very confusing because it lacks labels. The legend says series 1, series 2 and series 3. A series is a row of data. This is not enough information, which one is the sandwiches?  The charts axes are labeled with dollar amounts and the numbers 1 through 6. Again we want more information.  Is the number 1 January or June? We can add the labels manually after building the chart.

  1. Chart Tools tabs will open in the ribbon.

·         In Excel 2010 the tabs are labeled, Design, Format, and Layout.

·         In 2013 two Chart Tools tabs will open in the ribbon, Design and Format. On the left end of the Design tab there is an icon called Add Chart Element. To the upper right side of the chart you will see an icon of a large plus sign. Clicking on either one of these icons accesses the tasks that were performed using the Chart Tools Layout tab in Excel 2010.

·         In Excel 2011 for the Mac the chart tabs are Labeled Chart, Layout and Format. The Tab labeled Chart is the same as the tab labeled design in the PC versions.

·         In Excel 2016 for the MAC, there are two tabs, labeled Chart-Design and Format. As in Excel 2016 for the PC, the Layout Tab has been eliminated. It was replaced with the “Add Chart Elements” icon in the Chart-Design tab.

On the Design tab click on the Select Data icon to open a dialog box.  Let’s add the names of the months.

For the MAC:  Select the chart as a whole and right click it. Select the “Select Data….” Option. On the left side there is a drop-box that contains: series 1, series 2, and series 3. When you want to change them, simply click on one and then enter in the name on right side after “name:”.

  1. Click on the Edit option underneath the words “Horizontal Category Axis Labels. Click on the icon on the right end of Axis Label range textbox.

For the MAC: From the Charts Tab, select the Data option. Click in the data entry box to the right of “Category X axis labels”

 

  1. Click on the Sales Worksheet tab. Mouse over cells B3 to G3, the names of the months in row 3 of the Sales worksheet. Press Enter. Click OK twice.

 

It is simpler if you just include the labels when you select your data for the chart. Let’s delete the chart and start over. 

  1. Click on the chart and press the Delete key.

If we create the chart based on cells in the range A5 to G7, the legend will show the names for each row of data. This is not quite enough data; we also want to include the names of the months from row 3.

  1. Mouse over the cells in range A5 to G7 and then mouse over the cells in range A3 to G3.

Excel won’t let you keep both ranges selected. There is a trick we can use to select more than one range at the same time. After you have selected one range you can hold down the Control key and then mouse over more ranges.  This trick won’t work if you hold down Control when you highlight the first range of cells. You only hold down the Control key when selecting additional ranges.

For the MAC: Instead of holding down the “control” key, hold down the “command’ key.

  1. Click on cell A1 to deselect any ranges that were already selected. Mouse over the cells in range A5 to G7, hold down the Control key, and then mouse over the cells in range A3 to G3. Caution: make sure to include cell A3 as part of the selection. You get into trouble formatting the chart if the rows in your selection do not include the same number of cells. 

Select the chart type

  1. From the Insert tab on the ribbon click on the Bar icon. Select the 2D Type called Stacked Bar. The chart will appear in the same worksheet as the data. The Chart Tools tabs will open in the ribbon.

Move the chart into a new worksheet

  1. Click on the Move Chart icon in the Chart Tools Design tab of the ribbon.  Select the radio button in the move chart dialog box (the circles with a dot inside one of them are called radio buttons. You can only have one radio button selected at one time.) next to the “new sheet” option and type the word Bars into the text box to the right of the words “new sheet.” This will give the chart worksheet a name. Click OK.

For the MAC: After you have selected your chart, move your cursor to the top of your screen and your finder bar should pop up. Select charts and a drop-box should appear with the option “Move Chart”. After that select “new sheet” and type in the name “Bars”.

Customize the chart – Chart Tools Design tab

  1. On the Chart Tools Design tab (In Excel 2013 this tab is called Design) click on the pull-down arrow next to the chart styles. Click on the option in the bottom row of the second column. For Excel 2013 you can change the style of the chart through the Design Tab, or by using the middle icon to the right of the chart. From the Design tab, click on the eighth icon.

This is a great chart for a webpage or PowerPoint but would take a lot of ink if you tried to print it in a report.

  1.  Select the option in the fourth row of the second column. This gives the bars a nice 3-D appearance.  For Excel 2013 click on the fourth option in the styles on the Design tab. For the MAC: You can find all these various options under Charts: Layouts and Styles
  1. Select the option at the top of the second column; this is the chart design we started with. For Excel 2013 click on the second option in the styles on the Design tab.
  1. Click the pulldown arrow next to the chart layout group of icons. For Excel 2013 click on the Quick Layouts icon in the Design tab.  Mouse over the options in the third row to see how they affect the appearance of the chart. Notice the layouts are numbered. Select option 10; the layout we started with.

For Excel 2013 Click on the middle icon to the right of the chart. It looks like an old fashioned fountain pen. Select the Color tab. Mouse over some of the color options to see how they change the appearance of the chart. Do not make any changes. Click on the icon again to close the dialog box. 

I’ve seen a couple of MacBook users whose Y-AXIS labels showed numbers instead of the names of the months. I don’t know why. Perhaps they chose a different chart design in this set of steps and didn’t return to the original design.

Customize the chart – Chart Tools Layout tab

  1. From the Chart Tools - Layout tab, click on the Chart Title icon.  Select the “Above Chart” option. Click in the formula bar and type Food Sales. Press Enter.

For Excel 2013 all of the Layout options in steps 18 to 30 are under the Add Chart Element icon in the Design tab. You can also work with the plus sign icon to the right of the chart but the Chart Element icon on the Design tab is easier to use. 

  1. Our title only has one row of text, Food Sales. We can add more rows. Click on the Food Sales in the Chart Title textbox. Move the cursor to the end of the row of text and press Enter. Type the words “Java Juice.” Click outside the textbox to finish editing.
  1. If you clicked anywhere on the chart the Chart Tools tabs should still be open. If the tabs disappeared, click anywhere on the chart and they will reappear.
  1. Click on the Axis Titles icon. Select Horizontal. Choose the horizontal title option. Type in the words Sales Revenues and press Enter.
  1. Click on the Axis Titles icon. Select Vertical. Choose the vertical title option. Type the word Month into the formula bar and press Enter.
  1. Click on the Legend icon. You can use this icon to hide or move the legend box. You can also click and drag to move the legend box, so this icon is mainly used to hide the legend or to turn it back on. In Excel 2010 the Legend appears at the right of the chart. In Excel 2013 it appears below the chart. Select None.
  1. Click on the Legend icon. Select Right of Chart.
  1. Click on the Data Table icon. Select the Show Data Table option.  This shows all of the numbers and labels that were used to build the chart in a table underneath the chart. Adding a Data Table is useful if your chart will be used by people who don’t have access to your worksheet. 
  1. Click on the Data Table icon. Select the “Show Data Table with Legend” option. This will add color coding to the labels in the first column, next to each row of data. If you use this option you don’t need the legend.

Click on the Data Table icon. Select “None.”

  1. Click the Data Labels icon. Select Center. This will show the values of the data each bar represents. The labels will be centered in each bar.
  1. Click the Data Labels icon again and select More Label Options. Click on the check box next to Category Name. The name of the month will appear in one set of bars, but not all of them. I would like to have the category names appear on all bars but I don’t know how to do this with one click.
  1. Undo the changes in steps 27 and 28 to remove the labels and the revenue numbers from the bars.

Customize the chart – right-click method

You can change the appearance of anything in the worksheet by right-clicking on it and then choosing the Format (name of object) option, or through the text-formatting toolbox.

  1. You can customize the format of individual labels. Right click in the Revenues numbers below the chart. In Excel 2010 the text formatting toolbox will pop up. Unfortunately, this feature was removed in Excel 2013. In Excel 2013 you would need to select the Font option from the pop-up menu.  Change the font size to 14.

Using this method would be a slow process if you had to do this for each piece of text in the chart. Fortunately we can format everything at the same time. If you put the mouse pointer on top of some empty space in the chart you will see the words Plot Area appear. If you move the cursor to the empty space surrounding the chart you will see the words Chart Area. You can make changes to the entire chart by right-clicking in the Chart Area.

  1. Right click in the chart area. The text formatting toolbox will pop up. Change the font size to 14 and click on the Bold icon to make all the labels appear in bold font.  Click anywhere on the chart to accept the changes.

In Excel 2013, Right click in the chart area. Select Font. Change the “Font Style:” setting to Bold and the “Size:” setting to 14. Click OK.

Now we want to change the spacing of the grid lines and to change the value of the last gridline.

  1. Right click on the Revenues numbers below the chart. Choose Format Axis.
  1. Under Axis Options the Minimum setting is the value we want to use on the left side of the chart. Click the radio button(in 2010 only) next to Fixed.

In Office 2013 the radio buttons are gone and this setting is automatically set to Fixed. The values box shows the default “fixed” settings for this chart.  If you enter a different number into the values box the word Fixed is replaced with the word Reset. You can click on the word Reset to return to the default fixed value. 

Some students with a Mac, but not all, have had to click on Scale after opening the Axis Options dialog box.

We want to keep zero as the value on the left end of the horizontal axis. For some charts you might want to start with higher values than zero.

  1. Change the Maximum setting to 105,000 (Don’t include the comma!). This will be the value at the right side of the chart.
  1. Change the Major Units value to 15,000 (Don’t include the comma!). This changes the spacing between each gridline.
  1. Click Close to apply the changes. In Office 2013 the changes apply automatically. Close the task pane on the right.

Sometimes the numbers (or labels) at the bottom of the chart get crowded together and are hard to read. We can fix this by tilting the numbers.

  1. Right click on the Revenues numbers. Choose Format Axis. Choose Alignment. In Excel 2013 Click on the third icon in the Axis Options dialog box: Size and Properties”

      Enter a custom angle of 45 degrees. Click Close to apply the change. In Office 2013 the changes apply automatically. Close the task pane on the right.

In Office 2016 I tilted my texts by right clicking on the axis, then I clicked on ‘format axis’, then I went to ‘text options’ and ‘text box’ and the options are in the ‘text direction’ or ‘custom angle’.

  1. Click near the upper left corner of the legend and drag the legend to the lower right corner of the chart. Click and drag to make the legend larger.
  1. Right click in the plot area background. Select Format Plot Area, Fill (Text Fill for 2013) and Gradient Fill. Click on the pulldown arrow for preset colors.

For Excel 2010 select the fourth style in the first row; called Daybreak.  Click Close to apply the change.

For MAC and Excel 2013, Choose a light blue gradient. Change the Type to Radial and the Direction to From Center. In Excel 2013 a slider bar shows 4 gradient stops. Remove two of them. Select the first gradient stop and change the color to light red. Drag the second gradient stop into the center of the slider bar.

Customize the chart – Chart Tools Format tab

  1. Select the legend.  From the Chart Tools Format tab Click on the pulldown menu to the right of the Shape Styles set of icons. It’s on the right side of the image below the word Design. For the MAC the pulldown arrow is below the set of icons. Select the light blue shading in the fourth row.

  1. Click and drag the legend to the lower right corner of the chart area.
  1. Click in the Chart Area (the outside edge) Click on the Shape Fill icon, (One 2013 student needed to select Solid Fill to find the next option.) select More Fill Colors. Select a light yellow color. In Office 2013 you can right-click in the chart area and the fill option appears at the bottom of the pop-up menu. Note that Chart Area is also listed in a box on the bottom line. You can make a selection here if you want to change the background of another chart element.

Customize the chart – Insert tab

We can add graphic elements from the Insert tab of the ribbon.

  1. Click on the Shapes icon [ALT  N  S  H] on the Insert tab of the ribbon. Select the last banner shape from the stars and banners collection of icons. Click and drag in the upper right corner of the chart to create the shape. For the MAC, just click on the shape and click on the chart. Note: one MacBook Pro user was having trouble getting this to work. We never did figure out why. Release the mouse.
  1. Right click on the banner, select Edit text, and type your name. Click on the chart.
  1. In Excel 2010 Click on the Textbox icon [ALT  N  X] on the Insert tab. Select textbox.

Excel 2013 has a textbox option - click on the Text icon on the Insert Tab [ALT  N  Z  T  X] - but it doesn’t want to work with charts. Insert a rectangle shape instead.

The MAC doesn’t have textboxes. Insert a rectangle shape instead. Click and drag to create a rectangle covering the blue bar in the top row of the chart. Type the word Sandwiches in the textbox.

  1. Create a textbox, or insert a rectangle shape, covering the red bar in the top row of the chart. Type the word Soups in the textbox.
  1. Create a textbox, or insert a rectangle shape, covering the green bar in the top row of the chart. Type the word Desserts in the textbox.

Change the fill color of the textboxes to Black. 

You are finished with this chart.

 

2010 Chart

This is a picture of what the completed bar chart should look like.

2013 Chart

Chart Two: 3-D Stacked Column Chart

Show monthly Juice Sales for each of the months.

  1. Use the mouse to select cells A14 to G14 on the Sales worksheet.
  1. From the Insert tab, click on the Column icon [ALT  N  C] and select the “3-D Stacked Column” option.
  1. Right-click in the chart area (outside border.) Choose Move Chart. Select New Sheet and name it Column. Click OK.
  1. Add the names of the months underneath the columns. From the Chart Tools Design tab, click the Select Data icon. Click on the Edit option underneath the words Horizontal Category Axis Labels. Click the cell-selector icon inside the text box. Click on the Sales worksheet tab. Use the mouse to highlight cells B3 to G3. Press Enter. Click OK twice.
  1. Add a texture to the chart floor. From the Chart Tools Layout tab, click on the Chart Floor icon and select More Floor Options. Select the radio button next to Picture or Texture Fill. Click on the pull-down arrow next to the word Texture and select the Green Marble texture. Click Close.

For Excel 2013, right-click anywhere in the chart. In the Fill Outline dialog box that pops up, there is a text box. Click the pulldown arrow in the textbox and select Floor. Click on Fill and click on Texture. Click on the Green Marble texture.

For the MAC, Click on the Floor area of the chart. On the Format tab you should see the word “Floor” listed as the current selection in the upper left corner of the ribbon. Click on Format Selection and then click on Picture or Texture. Choose an option from the texture category.

  1. From the Chart Tools Layout tab, click on the Legend icon. Choose None.

Excel 2013 does not show a legend so you can skip this step.

  1. Right-click on the title and choose “edit text.” Change the title to “Juice Sales.”
  1. Click in the chart area (outside border). Choose Bold and a size 14 font in the text-formatting toolbox. In Excel 2013 right-click on the Chart Area and select the Font option from the pop-up menu. Change the “Font Style:” setting to Bold and the “Size:” setting to 14. Click OK.

56.  For Excel 2013, right-click anywhere in the chart. In the Fill Outline dialog box that pops up, select Walls. Click on Fill and click on More Fill Colors. Select a light yellow color.

For Excel 2010 Fill in the walls area background using a custom-designed two-color gradient.

    1. Right-click on the back wall. Select Format Walls. (It might say Format Plot Area) Select Gradient Fill. Do not close the dialog box!!! We have several more changes to make.
    1. In the same dialog box, next to the word Type, click in the box and select the Rectangular option.
    1. In the Direction box select the middle option, From Center.

 

A picture of the Gradient Stops tool.

 

 

    1. You will be using two stops. Each of the downward pointing icons on the slider bar is a stop. The image shows three stops. Remove any extra stops by clicking on the stop pointer icon then clicking on the red icon to the right of the slider bar.
    1. Select the marker for Stop 1. Change the color to yellow. Increase the transparency to 50%. Move this marker to the center of the slider bar
    1. Select the marker for Stop 2. Change the color to light green. Move this marker to the right end of the slider bar.
    1. Ok, we’re done. Click on Close.

57.  For Excel 2013, right-click on one of the columns.  Select Format Data Series. In the task pane click on the “Fill and Lines” paint can icon. Click on Pattern Fill. Set the Foreground color to Green and the Background color to Yellow. The patterns should be showing in the task pane.  Select the second pattern in the second row. It is labeled 60%. Close the task pane.

For Office 2010 fill the columns of your graph with a preset-color gradient. Right-click on one of the columns. Select Format data Series. Click on the word Fill on the right side of the dialog box. Select the radio button next to Gradient Fill. Click on the pull-down arrow next to Preset colors. Choose the Moss option. The MAC doesn’t have a Moss preset gradient. Choose your own color, gradient, or texture. Click on Close.

You are finished with this chart.

Excel 2013 Chart

Excel 2010 Chart

This is a picture of what the completed column chart should look like.

Chart Three: Line Graph with Markers (Not Stacked)

Show Total Food Sales, Total Beverage Sales, and Net Revenue, by month.

58. Use the mouse to select cells A3 to G3 on the Sales worksheet. Now you will need to select three more rows.

59. Hold down the Ctrl key. For Macs hold down the Command and Control keys. Mouse over cells A8 to G8, A16 to G16, and A22 to G22. Release Ctrl. 

There are a couple of ways to mess this up. One is by clicking on individual cells when you select the data instead of mousing over entire rows of data.  Another is by holding down the control key when you select the first row of data.

60. From the Insert tab, Chart group, Line icon [ALT  N  N], select the first chart in row 2, “Line with Markers”

61. Right-click in the chart area (outside border.) Choose Move Chart. Select New Sheet and name it Line. Click OK.

62. From the Chart Tools Layout tab, click on the Chart Title icon. Select Above Chart. You can skip this step in Excel 2013. The Chart Title box is included when you build the chart.

63. Change the title. Click in the chart title box. Click in the Formula bar. Type Sales and Net Revenue and press Enter.

64. From the Chart Tools Layout tab click the Legend icon. Select Show Legend at Top. In Excel 2013 click on the plus icon at the top right of the chart. Click on the arrow to the right of the word Legend and select Top.

65. Click in the chart area (outside border). Choose Bold and a size 14 font in the text-formatting toolbox. In Excel 2013 right-click on the Chart Area and select the Font option from the pop-up menu. Change the “Font Style:” setting to Bold and the “Size:” setting to 14. Click OK.

66. Click on the marker on the (blue) Total Food Sales line. Right-click and select Format Data Series.

In Excel 2010 Choose Line Style. Change the width to 3. Choose Marker Options on the left. Click Built-in. Increase the marker size to 11. Click Close to apply the changes.

In Excel 2013 the formatting task pane opens. Click on the Fill and Line icon, it looks like a paint can. Under the Line tab, change the width to 3. Under the Marker tab select Marker Options. Change the size to 11. Close the task pane.

67. Make the same changes to the Beverage Sales and Net Revenue lines.

68. For Excel 2010 Fill in the plot area background with a pattern. Right-click in the plot area, below one of the lines. Select Format Plot Area. Click on the radio button next to Pattern Fill. Select the fourth pattern in the first column. Click on Close.

For Excel 2013, right-click in the plot area. Select Format Data Series. In the task pane click on the “Fill and Lines” paint can icon. Click on Pattern Fill. Set the Foreground color to Blue and the Background color to White. The patterns should be showing in the task pane.  Select the first pattern in the fourth row. It is labeled light vertical. Close the task pane.

69. Add a rectangle shape above the top line, net revenue. Type the name of the series, Net Revenue, into the text box. Mouse over the text and increase the font size to 14.

70. Add similar rectangles with labels to name the other two lines.

You are finished with this chart.

Excel 2010 Chart

 

This is a picture of what the completed line chart should look like.

Excel 2013 Chart

 

71. Click on the F12 function key. Save the file. You will be using this workbook for the Charts2 assignment.

Review – Fine Points

Create a Chart     Time    = 3:33

https://www.youtube.com/watch?v=TZxcoUhCLjk

 

Format a Chart     Time    = 3:13

https://www.youtube.com/watch?v=Gksy2anwCqw

 

Select Non-adjacent Cells using SHIFT+F8   1:45

 

Instructions for the Check for Understanding (CFU) form.

A CFU form is turned in for every assignment.

Starting with the line for your name, copy and paste the CFU form into a Word document.

Fill in your name, date, section number

Circle (or indicate by highlighting) a Y or N response for each statement. I do not subtract points for No answers.

Below the list of Y/N statements, insert ONE screenshot of any part of your work. I just need to see something to prove that you did the assignment. I don’t need to see all of the assignment.  Resize the screenshot, if necessary, so both the form and graphic can fit on one page.

A copy of the CFU is due to be turned in during the next class session.  I do not accept CFU’s through email. 

 

 

Name _______________________________      Date___________       Section _______

Check for Understanding – Excel Charts 1

Y/N I can create a bar chart.

Y/N I can select ranges from different areas on the worksheet using the Control key.

Y/N I can use the tools on the Chart Tools Design tab / Chart Elements Icon.

Y/N I can use the tools on the Chart Tools Layout tab.

Y/N I can right-click methods to format chart objects.

Y/N I can use the tools on the Chart Tools Format tab.

Y/N I can add textboxes, clip art, and graphics to charts.

Y/N I can create a column chart.

Y/N I can create a line chart.