1 / 37

A Picture Is Worth A Thousand Words

A Picture Is Worth A Thousand Words. Day 7: Excel Chapter 4. Tazin Afrin Tazin.Afrin@mail.wvu.edu September 10, 2013. Chart Basics. A chart is a visual representation of numeric data Chart components: Data Points: numeric value that describes a single value on a chart.

ilya
Download Presentation

A Picture Is Worth A Thousand Words

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. A Picture Is Worth A Thousand Words

  2. Day 7:Excel Chapter 4 Tazin AfrinTazin.Afrin@mail.wvu.edu September 10, 2013

  3. Chart Basics • A chart is a visual representation of numeric data • Chart components: • Data Points: numeric value that describes a single value on a chart. • Data Series: a group of related data points. • Category Labels: text that describes a collection of data points in a chart.

  4. Sample dataset

  5. Column Charts • A column chart displays data vertically, with each data series forming a column • The chart area contains the entire chart and all of its elements. • The plot area contains a graphical representation of values in a data series.

  6. Column Charts Y Value Axis X Category axis

  7. Legend • A legend is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart.

  8. Clustered Column Chart • A clustered column chart groups or clusters similar data in columns to compare values across categories.

  9. Clustered Column Chart Legends

  10. Reversing Categories and Data Series

  11. Stacked Column Chart • A 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.

  12. Stacked Column Chart

  13. 100% Stacked Column Chart • A 100% stacked column chart places (stacks) data in one column per category, with each column having the same height of 100%.

  14. 100% Stacked Column Chart

  15. 3-D Column Chart • A 3-D chart adds a third dimension to each data series, creating a distorted perspective of the data.

  16. 3-D Column Chart

  17. Bar Chart • A bar chart compares values across categories using horizontal bars.

  18. Bar Chart

  19. Line Chart • A line chart uses a line to connect data points in order to show trends over a period of time.

  20. Line Chart

  21. Pie Chart • A pie chart shows each data point in proportion to the whole data series as a slice in a circular pie.

  22. Pie Chart

  23. X Y (Scatter) Chart • An X Y (scatter) chart shows a relationship between two variables.

  24. X Y (Scatter) Chart

  25. Creating a chart • Select the data source • Select the chart type • Position and size the chart

  26. Creating a chart • Shortcut Key: • Pressing F11 is a fast way to create a column chart in a new chart sheet. Select the worksheet data source, and then press F11 to create the chart.

  27. Changing the Chart Type • Using the Chart Tools contextual tab: • Click the Design tab • Click Change Chart Type • Select the desired chart type

  28. Changing the Data Source • To modify the chart data source: • Click the Design tab • Click Select Data under the Data group • Then change data range

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

  30. 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

  31. Chart Layout • The Layout tab offers many ways to enhance a chart visually • When adding visual elements to a chart, make sure these elements enhance the effectiveness of the chart instead of overpowering it.

  32. Selecting and 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 (ex. Format Data Series)

  33. Customizing Chart Labels • Chart Title • Axis Title • Legend • Data Labels • Data Table

  34. Chart Titles and Legend • 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

  35. Axes and Gridlines • 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

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

  37. Thank You Log Off

More Related