1 / 32

Day 7: MICROSOFT EXCEL – CHAPTER 4

Day 7: MICROSOFT EXCEL – CHAPTER 4. Akhila Kondai akhila.kondai@mail.wvu.edu September 09, 2013. Announcements. The First Assignment will be due by 09/13/2013 by 11.59pm MyITLab Lesson B is due on 09/16/2013 by 11.59pm

xenon
Download Presentation

Day 7: MICROSOFT EXCEL – CHAPTER 4

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Day 7:MICROSOFT EXCEL – CHAPTER 4 AkhilaKondai akhila.kondai@mail.wvu.edu September 09, 2013

  2. Announcements • The First Assignment will be due by 09/13/2013 by 11.59pm • MyITLab Lesson B is due on 09/16/2013 by 11.59pm • The Second Assignment is also posted and is due on 09/20/2013 by 11.59pm

  3. Microsoft Excel – Chapter 4.

  4. Chart • Chart gives visual representation of Excel sheet workbook • They allow us to interpret large amount of data easily and quickly.

  5. Chart components • Data Points - A data point is a numeric value that describes a single value on a chart. • Data Series - A data series is a group of related data points. • Category Labels - A category label is text that describes a collection of data points in a chart. • The chart area contains the entire chart and all of its elements. The plot area contains the graphical representation of values in the data series. The X-axis (Category axis) is a horizontal line. The Y-axis (Value axis) is a vertical line.

  6. Chart components

  7. Basic chart types • Pie – Compares parts with the whole • Column – Shows/compares values across different categories • Line charts – Shows trends over time • X-Y Scatter chart – compares pair of values, usually looking for a trend • Other types: Area chart, Stock chart, Surface chart, Doughnut chart, Bubble chart, Radar chart

  8. What they look like Pie Column chart

  9. What they look like.. Line Chart X-Y Scatter plot

  10. Choosing the correct chart type • Choose the chart type that best fits the data • For comparing values from different categories, use • Column, Bar, or Line Chart • For comparing individual values to a whole collection, use • Pie or Doughnut Chart

  11. Creating a Chart • Three main steps to create a chart • Select the Data Source that is the range of cells to chart • Select the chart type • Position and size the chart • You can change the properties of chart using several options available in the LAYOUT ribbon.

  12. Column Chart • A column chart displays data vertically, with each data series forming a column • Go to my lecture notes page, download the ‘majors’ Excel file and open it. • Select the cells A4:A11 and E4:E11 • Insert Tab -> Column chart in Charts section

  13. Clustered Column Chart • Groups or clusters similar data in columns to compare values across categories. • Select the cells A4:E11 • Insert Tab -> Column chart in Charts section (Clustered column chart) • Legendis a key that identifies color, gradient, picture, texture, or pattern fill assigned to each data series in a chart

  14. Stacked Column Chart • Places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color. • Select the cells A4:E11 • Insert Tab -> Column chart in Charts section (Stacked column chart) • Right click on the chart and select “Select Data” and click “ Switch row/columns ”

  15. 100% Stacked Column Chart • Compares the percentage that each data point contributes to the total for each category. • Select the cells A4:E11 • Insert Tab -> Column chart in Charts section (100% Stacked column chart) • Right click on the chart and select “Select Data” and click “ Switch row/columns ”

  16. Bar Chart • Bar chart compares values across categories using horizontal bars. • Width of the bar indicates its value. • Create a Bar Chart for the given Majors work sheet

  17. Line Chart • Line chart uses a line to connect data points in order to show trends over a period of time. • Different color for each data series. • Create a Line Chart for the given Majors work sheet.

  18. Pie Chart • Pie chart shows each data point in proportion to the whole data series as a slice in a circular pie. • To create a pie chart for 2012, Select the cells A4:A11 and E4:E11 • Insert Tab -> Pie chart in Charts section

  19. Separating Parts of Pie (Exploding Pie) • Single Part Separation/Explosion • Make two slow clicks on one of the pieces • Left click and drag it outward • Full chart explosion/Separation • Make sure nothing is selected • Hold down the left button on one of the pieces and drag it outward

  20. Changing the Chart Type • Click the Design tab • Click Change Chart Type in the Type section • Select the desired chart type and click OK • For example you can change a stacked column chart to 100% stacked column chart

  21. Changing the Data Source

  22. Moving a Chart • To move a chart: • Click the Design tab • Click Move Chart under the Location group

  23. Printing a Chart • To print an embedded chart: • Select the chart • Click the File tab • Click Print to display the Backstage view • Use the Print Selected Chart option • To print a chart sheet: • Use the Print Active Sheet option

  24. Creating a Sparkline • A Sparkline is a miniature chart displayed in a single cell • To create a sparkline • Click the Insert Tab • Click Line, Column, or Win/Loss in the Sparklines group.

  25. Chart Layout • The Layout tab offers many ways to enhance a chart visually by selecting specific chart elements, inserting objects, displaying or removing chart elements, customizing the axes and formatting background.

  26. Formatting Chart Elements • Formatting a chart element: • Right-click the element and select the Format element command • The element portion will change depending on the selection

  27. Customizing Chart Labels • A chart title is the label that describes the entire chart • An axis title is a label that describes either the category or value axis • A legend is used to distinguish data points in a pie chart or data series in a multiple series chart • A data label is the value or name of a data point • A data table is a grid that contains the data source values and labels.

  28. Axes and Gridlines • Based on the data source values, Excel computes starting, ending, and incremental values for display on the value axis. • A gridline is a horizontal or vertical line through the plot area.

  29. Adding a Trendline • A trendline is a line used to depict trends and forecast future data.

  30. Trendlines • Trend Types • Linear • Exponential • Logarithmic • Polynomial • Power etc.,. • Forecast • R-Squared Value

  31. Next Class • Working with Tables and Worksheets. • Homework # 1 overview

  32. Questions ?

More Related