MO Lesson 2.9 - Create Charts and Graphs 2024 Warm Up Removed.pptx

Learners can:

• differentiate charts and graphs
• identify the usefulness of various charts
• explain ways to format a chart

Warm Up: Each day we will begin with a question or activity to get us started!

Monday, Wednesday, Friday 2:20-3:05 pm

Welcome to Microsoft Office Mrs. Vandernick lvandernick@ccaeducate.me (717) 710-3300 extension 11814

The Plan for Today: Unit 2 Lesson: 2.9 Create Charts and Graphs Goals:

• Analyze Chart
• Chart
• Data series
• Graph
• Legends

Vocabulary

• Companies collect information about their past performance, which tells the story of:
• Gains
• Losses
• Expenses services
• This information is important, but it is not easy for everyone to read and understand.
• Graphs are used to show the information in a way that is easy to understand.
• Charts help companies see patterns and trends, which can help struggling companies improve and successful companies become even more profitable.

Why Use Charts and Graphs?

• A chart is a visual representation of data or information that typically presents data points or sets in a clear and concise manner.
• A graph is a specific type of chart that typically uses a coordinate system to plot data points and display the relationship between two or more variables.

Charts and Graphs

• Excel charts are a valuable tool for visually presenting information in a clear and comprehensible manner.
• They transform data into visual representations that assists:
• Pattern recognition
• Comparison
• Trend analysis
• Extraction of key insights
• Enhances the visual appeal and engagement of the information displayed.
• Common Types of Excel Charts:

Charts and Graphs

• A column chart uses vertical bars to show information.
• Each bar represents a group, and its height shows the value.
• It helps compare things over a period of time or items side-by-side.

Column Chart

• A line chart connects data points with lines.
• It shows how things change over time.
• It is best to have multiple rows of information to make multiple line so the chart is more appealing.
• There are different style of line charts; ones with markers and ones without.

Line Chart

• A pie chart is a circle divided into slices, showing different parts of a whole (percentages).
• Each slice's size represents the proportion.
• You have only one data series.
• It is good to use a pie chart when:
• None of the values are negative.
• When there are no zero values.
• When there are less than seven categories

Pie Chart

• A bar chart is like a column chart, but the bars are horizontal.
• Bar charts compare individual items with the category on the vertical axis and the values on the horizontal axis.
• Bar charts are good to use when you have large amount of data that need a longer space to be represented horizontally.

Bar Chart

Question...

• Excel is well-known for its ability to produce various types of charts and graphs to help users comprehend their data.
• It is helpful to familiarize yourself with less commonly utilized charts.
• Less Common Charts in Excel
• Histogram chart- A histogram is like a bar chart, but instead of comparing different things, it shows how information is spread within one group.
• Scatter chart- Scatter charts help show and compare numbers
• Waterfall chart- Waterfall charts show how changes, like adding or subtracting, affect a starting value over time
• Combo chart- A combo chart is a combination of two or more charts.

Charts and Graphs

Here is a brief overview of the process:

1. Select the data to include in the chart.
2. Press on the Insert tab in the Excel Ribbon, and select the desired chart type.
3. Once the chart is inserted, customization options like chart title, axes labels, data series, and colors will appear in the Ribbon.
4. The chart will be automatically updated if changes are made to the spreadsheet data.

Creating a Chart in Excel

• A data series is just a set of information in Excel to show on a graph.
• For example, if the sales data for a sales team over the course of a year is considered, it may be best to create a separate data series for each salesperson.
• Excel has an innovative feature called Analyze Data, which helps analyze data faster and easier.
• This feature provides options for visualizing data, like charts and tables, with just a few presses.
• Several steps are taken to use the Analyze Data feature:
• Select the data series to analyze.
• Open the shortcut for Analyze Data.
• Preview charts to select the best fit.

Analyzing Data

• To create a comprehensive and readable Excel chart, it is necessary to include various components, such as:
• Chart titles – to help people understand what the chart shows
• Legends – a box that explains the colors or patterns used to represent each data series
• Axis titles – make it clear what units and scales are being used, while data labels help identify trends and patterns in the data.
• These elements work together to provide context and clarity, allowing the reader to interpret and understand the data effortlessly.
• Adding chart titles, legends, and axis labels in Excel can improve the readability of a chart.

Making Excel Charts More Readable

Chart Title

• Double- press on the chart to select it.
• Press on the Chart Title options located in the Chart pane.
• Choose where the chart title will appear (Above Chart, Centered Overlay Title, or Centered Overlay Title on Chart) and type in the title in the text box.

Chart Titles and Axis Labels

Axis Labels

• Double- press on the chart to select it.
• Press on the Chart Title options located in the Chart pane.
• Check the box next to Data Labels.
• Press on the Data Labels button that appears on the chart.
• Select the type of axis label, such as Primary Horizontal or Primary Vertical, or select More Options to customize the axis labels further.

Chart Titles and Axis Labels

Question...

Question...

Question...

Question...

Question...

• Today, you learned:
• to differentiate charts and graphs;
• to identify the usefulness of various charts; and
• to explain ways to format a chart.
• In an upcoming lesson, you will learn about Automation and Data Clean-up

Have a great day and I’ll see you next time!

Summary