1 / 31

Charts and Graphs

Charts and Graphs. Topic 7: Visualization Lesson 1 – Creating Charts in Excel. Charts. Data is often better explained through visualization as either a graph or a chart. Excel makes creating charts easy: Column Charts Pie Charts Bar Graphs Line Graphs Area Graphs Scatter Plots

ashley
Download Presentation

Charts and Graphs

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. Charts and Graphs Topic 7: Visualization Lesson 1 – Creating Charts in Excel

  2. Charts Data is often better explained through visualization as either a graph or a chart. Excel makes creating charts easy: Column Charts Pie Charts Bar Graphs Line Graphs Area Graphs Scatter Plots Charts can be found on the Insert Tab

  3. Sample Data Here’s some sales data that we would like to visualize:

  4. Pie Charts A pie chart is useful when you are trying to show proportions. How much of the sales revenue comes from each client? Who are our largest clients?

  5. The Chart Layout

  6. Creating a Pie Chart Select the data and the headers Go to Insert tab Within the Charts section, click on Pie Then select a type of pie chart jys

  7. Customizing a Chart Use the Chart Tools Tabs to customize a Chart Design Tab Format Tab

  8. A Customized Version of the Same Pie Chart Use the Design tab to change the look of the Chart or to Add additional chart elements Use the Format tab to rearrange items in the chart

  9. Transparency creates a Minimal Display Choosing a transparent background for a chart is useful for creating a worksheet that minimizes chart details and simply shows a small graphic to support a set of numbers

  10. Other Formatting Options The ‘+’ icon allows you to add a new chart element The paintbrush icon allows you to change the format of the item The funnel icon allows you to limit the data in the chart Format panel allows you to customize any chart element selected

  11. Column Chart Also known as a bar chart, with rectangular bars of lengths usually proportional to the magnitudes or frequencies of what they represent. The bars are vertically oriented in a column chart Useful for showing data changes over a period of time, or illustrating comparisons of groups Categories organized on horizontal axis Values on vertical axis

  12. Column chart Same data, different chart type

  13. Line Graph Often used to plot changes in data over time such as weekly temperature changes or stock market prices If plotting changes over time: Time is plotted along the horizontal or x-axis Data is plotted as individual points along the vertical axis

  14. Line Graph

  15. High, Low, Close Graph Used to illustrate the fluctuation of stock prices or for scientific data The data should be arranged with stock names as row headings, and High, Low and Close entered as column headings In “Stock” Charts in Excel

  16. High Low Close: Data and Chart

  17. X/Y Scatter Plot Useful for determining how two variables relate to one another e.g. profits vs. expenditures, height vs. weight, etc. Each data point has more than one attribute Person (height, weight) Quarter (profit, expenditure) Each attribute on a single axis

  18. X/Y Scatter Plot

  19. Assigning a Series to a Secondary Axis A secondary value axis can make it easier to compare data series that have deviating ranges. Example: a series showing number of units sold per year has a range that is much higher than cost per unit per year. The difference in range makes it difficult to see how they relate to each other. Putting one of the series on a secondary axis makes it possible to compare the variables

  20. Assigning a Series to a Secondary Axis The line graph on the left shows two data series with widely differing ranges, so it’s hard to compare them. The graph on the right, plots one series on a secondary axis making it easier to compare and identify the inverse relationship. To move a series to a secondary axis, right-click on the series, click Format Data Series, select Series Options then select Secondary Axis.

  21. Trendlines, Error Bars, etc. Excel also provides statistical analysis tools via the Design tab / Add Chart Element icon (Excel 2013, 2016) or the Layout tab / Analysis section (Excel 2010) . Trendlines show the “best fit” for the data. Error bars show “confidence intervals” around data points.

  22. Sparklines New to Excel 2010, we can also create charts or graphs that live within one cell Their inventor, Edward Tufte, describes them as “intense, simple, word-sized graphics” Meant to be embedded into what they are describing Presents the general shape of variation in some measurement, in a simple and highly condensed way

  23. To Create Sparklines: Select the cell where you want the Sparkline to appear Click the Insert tab andlook for the Sparklines group Choose the data range and the location for the Sparkline.

  24. Merging Cells To make sparklines bigger, you can merge multiple cells into a single cell. In the home tab:

  25. Common Issues: data labels Data labeled “Series1”

  26. Common Issues: data labels Data labeled “Series1” To fix it: Select Data

  27. Common Issues: data labels Data labeled “Series1” To fix it: Select Data Edit Series Name

  28. Common Issues: axis labels Axis labels plotted instead

  29. Common Issues: axis labels Axis labels plotted instead To fix it: Select Data

  30. Common Issues: Axis Labels Axis labels plotted instead To fix it: Select Data Remove axis series Edit Axis Labels

  31. Any Question?

More Related