Susan Fuschetto
CIS 151 Excel For I.T.
Excel Assignment 3 - Charts: Delivering a Message
This chapter is about charting data and using the right charts for
your message. Please be sure to read all of the chapter to
understand how to choose the appropriate charts. Also, if you are
used to older versions of Excel and are familiar with the Chart Wizard,
then you will see a big difference in how to do charts and change chart
options. I am still getting used to the new way as well.
Basically the chart wizard commands are now on the Insert Tab, Charts
group. And then as you have the chart selected you will see
contextual tabs appear such as the Design, Layout, and Format tabs.
These are similar to the chart options in previous versions of Excel.
Well, hmmm... I hope that helps.
Please be patient with the steps in the book. I think they
could have been written a little better. Here are some of the
things I think need clarification:
Page 205, Step 6, item e. "Click the plot area..." Click near
the pie chart, but not on it to get the square around the pie.
That is the plot area.
Page 223, item d. Your document might overflow to the second page.
Resize the Revenue by City chart so that the document fits on one page.
Page 223, item b. "Double-click the worksheet..." This did not
work for me. It did not open up a separate Excel window. I
had to right-click the worksheet, select Worksheet Object from the
shortcut menu, then select Open. This command opened up Excel and
the workbook.
Page 225, Step 9, item c. After you click the Save button you
may get another dialogue box. Click the Publish button.
Page 225, Step 9, d. "... preview the chart..." This means you
have to open up the .htm file you just saved/published using your Web
browser such as Internet Explorer.
Well I hope these notes help.
- Read Excel Chapter 3 pages 187 - 225.
- Do all three of the hands-on exercises
described on pages 187 - 225.
- Do Practice Exercise #2, AnytimeTalk,
Inc. - Chart Formatting on pages 231 - 232. Make sure you
refer to figure 3.42 on page 232 as you are working on this
assignment. The formatting does not have to be exactly like
the figure, but please come close to it. I believe for step n. the
chart the formats are Border Color: Solid, Orange; Border Style: 3
PT, Rounded; and Shadow, Presets: Offset Center, Orange. Do
the best you can.
- Online students: Upload the
chap3_ho3_sales_solution.xlsx,
chap3_ho3_memo_solution.docx, and
chap3_pe2_talk_solution.xlsx files to
the Excel 3 assignment on the class website.
- Traditional students:
During the lab time show the three files
on your computer screen to me.
Last update:
02/17/09 |
