SlideShare a Scribd company logo
Working with chartsLESSON 11
A chart is a tool you can use to communicate your data graphically. Charts often help an audience to see the meaning behind numbers and make showing comparisons and trends easy. In this lesson, you will learn how to insert and modify charts and see how they can be an effective tool for communicating information.
To Insert a Chart:Select the Insert tab.Click the Insert Chart command. The Insert Chart dialog box appears.
Click and drag the scroll bar to view the chart types, or click a label on the left of the dialog box to see a specific chart style.
Click a chart to select it.Click OK. Excel will open. Usually, Excel will appear on one side of the screen, while PowerPoint appears on the other side of the screen.If a slide layout has a content placeholder, click the Insert Chart command to insert a new chart
Enter Chart DataThe data that appears in the Excel spreadsheet is placeholder source data that you will replace with your own information. The Excel source data is used to create the PowerPoint chart.
To Enter Chart Data:Select a cell in the Excel spreadsheet.Enter your data in the cell. If the cell contains placeholder data, the placeholder data will disappear. As you enter your data, it will appear in the Excel spreadsheet and the PowerPoint chart.Move to another cell.Repeat the above steps until all your data is entered.
Click and drag the lower-right corner of the blue line to increase or decrease the data range for columns. The data enclosed by the blue lines will appear in the chart.Click and drag the lower-right corner of the blue line to increase or decrease the data range for rows
Select any cells with placeholder data remaining. In the example, the column with Series 3 data was not needed.
Press the Delete key to delete the remaining placeholder data.Close Excel. You do not need to save the spreadsheet. The new Excel source data appears in the PowerPoint chart.
Formatting ChartsWhen you insert a chart, three new tabs will appear on the Ribbon. The three tabs -- Design, Layout, and Format -- contain various chart tools and commands that allow you to modify and format the chart.
To Change the Chart Type:Select the chart.Select the Design tab.Click the Change Chart Type command. The Insert Chart dialog box will appear.
Select the chart you would like.Click OK. The chart will change on the slide to the new chart type.
To Edit Source Data:Select the chart.Select the Design tab.Click the Edit Data command. An Excel spreadsheet with the current source data will appear.Edit the data in the spreadsheet. The changes will appear on the slide.Close Excel without saving the spreadsheet.
To Change the Chart Style:Select the chart.Select the Design tab.Scroll through the options in the Chart Style group, or click the More drop-down arrow to see all the chart style options.
Click a chart style to select it. The chart style will change on the slide.
Identifying the Parts of a Chart
Source DataThe range of cells that make up a chart. The chart is updated automatically whenever the information in these cells change.TitleThe title of the chart.LegendThe chart key, which identifies what each color on the chart represents.AxisThe vertical and horizontal parts of a chart. The vertical axis is often referred to as the Y axis, and the horizontal axis is referred to as the X axis.
To Change the Chart Layout:Select the chart.Select the Design tab.Scroll through the options in the Chart Layout group, or click the More drop-down arrow to see all the chart layout options.Click a chart layout to select it. The chart layout will change on the slide.The chart layout determines how specific chart information will appear. For example, some layouts include chart titles, legends, and axis labelsTo Modify Specific Areas of the Chart LayoutSelect the chart.Select the Layout tab.Locate the Labels group.
Chart Titles:Click this command to remove or add a chart title.
Axis TitleClick this command and choose to hide or display the horizontal, or x axis, label; hide or display the vertical, or y axis, labels; and change the direction of the axis labels to horizontal or vertical.
LegendClick this command to select a location for the legend to appear, or choose to not display a legend.
Data LabelsClick this command to display or hide data values next to each chart element.
Other Important Commands on the Layout TabIn the Axes group, there are several commands that control both axes and whether the gridlines are visible. In the Background group, there are several commands that control the visual aspects of the chart. Some commands in the Analysis group will appear active only if the selected chart is a line, area, or bubble chart.
Additional Chart FormattingUse the commands on the Format tab to modify the chart in additional ways. For example, from this tab you can change the chart outline, format chart text as WordArt, and more.
ChallengeUse the Company Overview presentation or any other PowerPoint presentation you choose to complete this challenge.Open a presentation.Insert a bar chart.Change the chart to a line chart.Change the chart layout.Apply a different chart style.Add axis labels if they are not included on the layout you chose.
Lesson 10   working with charts
Ad

More Related Content

What's hot (18)

Making a Chart Using Excel
Making a Chart Using ExcelMaking a Chart Using Excel
Making a Chart Using Excel
rebelbrindley
 
Excel basics
Excel basicsExcel basics
Excel basics
Lotus Yon
 
How to Insert a Graph into Microsoft Excel 2007
How to Insert a Graph into Microsoft Excel 2007How to Insert a Graph into Microsoft Excel 2007
How to Insert a Graph into Microsoft Excel 2007
nfasano
 
Formatting in MS Excel
Formatting in MS ExcelFormatting in MS Excel
Formatting in MS Excel
Muhammad Yasir Bhutta
 
Create A Chart In Excel
Create A Chart In ExcelCreate A Chart In Excel
Create A Chart In Excel
Brian Lowery
 
Print16
Print16Print16
Print16
Hassan Samoon
 
Lesson 16 Working With Charts
Lesson 16   Working With ChartsLesson 16   Working With Charts
Lesson 16 Working With Charts
guevarra_2000
 
Creating graphs in excel
Creating graphs in excelCreating graphs in excel
Creating graphs in excel
clynnc
 
Module 6 component of excel chart
Module 6 component of excel chartModule 6 component of excel chart
Module 6 component of excel chart
Dr. Shalini Pandey
 
Lesson 9 working with text boxes
Lesson 9   working with text boxesLesson 9   working with text boxes
Lesson 9 working with text boxes
guevarra_2000
 
Working with charts in word 2003
Working with charts in word 2003Working with charts in word 2003
Working with charts in word 2003
Vidya Kalaivani Rajkumar
 
Module 6 (2) type of excel chart
Module 6 (2) type of excel chartModule 6 (2) type of excel chart
Module 6 (2) type of excel chart
Dr. Shalini Pandey
 
Excel Basics
Excel BasicsExcel Basics
Excel Basics
Leslie Noggle
 
Lesson 18 Creating Pivot Tables
Lesson 18 Creating Pivot TablesLesson 18 Creating Pivot Tables
Lesson 18 Creating Pivot Tables
guevarra_2000
 
Les19 Working With Tables
Les19 Working With TablesLes19 Working With Tables
Les19 Working With Tables
guevarra_2000
 
How To Use Excel
How To Use ExcelHow To Use Excel
How To Use Excel
Julia Happel
 
Lesson 4 themes and background styles
Lesson 4   themes and background stylesLesson 4   themes and background styles
Lesson 4 themes and background styles
guevarra_2000
 
MS-Excel Working with Pivot Table
MS-Excel Working with Pivot TableMS-Excel Working with Pivot Table
MS-Excel Working with Pivot Table
P. SUNDARI ARUN
 
Making a Chart Using Excel
Making a Chart Using ExcelMaking a Chart Using Excel
Making a Chart Using Excel
rebelbrindley
 
Excel basics
Excel basicsExcel basics
Excel basics
Lotus Yon
 
How to Insert a Graph into Microsoft Excel 2007
How to Insert a Graph into Microsoft Excel 2007How to Insert a Graph into Microsoft Excel 2007
How to Insert a Graph into Microsoft Excel 2007
nfasano
 
Create A Chart In Excel
Create A Chart In ExcelCreate A Chart In Excel
Create A Chart In Excel
Brian Lowery
 
Lesson 16 Working With Charts
Lesson 16   Working With ChartsLesson 16   Working With Charts
Lesson 16 Working With Charts
guevarra_2000
 
Creating graphs in excel
Creating graphs in excelCreating graphs in excel
Creating graphs in excel
clynnc
 
Module 6 component of excel chart
Module 6 component of excel chartModule 6 component of excel chart
Module 6 component of excel chart
Dr. Shalini Pandey
 
Lesson 9 working with text boxes
Lesson 9   working with text boxesLesson 9   working with text boxes
Lesson 9 working with text boxes
guevarra_2000
 
Module 6 (2) type of excel chart
Module 6 (2) type of excel chartModule 6 (2) type of excel chart
Module 6 (2) type of excel chart
Dr. Shalini Pandey
 
Lesson 18 Creating Pivot Tables
Lesson 18 Creating Pivot TablesLesson 18 Creating Pivot Tables
Lesson 18 Creating Pivot Tables
guevarra_2000
 
Les19 Working With Tables
Les19 Working With TablesLes19 Working With Tables
Les19 Working With Tables
guevarra_2000
 
Lesson 4 themes and background styles
Lesson 4   themes and background stylesLesson 4   themes and background styles
Lesson 4 themes and background styles
guevarra_2000
 
MS-Excel Working with Pivot Table
MS-Excel Working with Pivot TableMS-Excel Working with Pivot Table
MS-Excel Working with Pivot Table
P. SUNDARI ARUN
 

Viewers also liked (8)

Lesson 1 setting up excel environment
Lesson 1   setting up excel environmentLesson 1   setting up excel environment
Lesson 1 setting up excel environment
guevarra_2000
 
Chap1 Business Ingeneral
Chap1 Business IngeneralChap1 Business Ingeneral
Chap1 Business Ingeneral
guevarra_2000
 
Trig m1 handouts
Trig m1 handoutsTrig m1 handouts
Trig m1 handouts
guevarra_2000
 
Lesson 10 computer systems hardware
Lesson 10 computer systems hardwareLesson 10 computer systems hardware
Lesson 10 computer systems hardware
guevarra_2000
 
Lesson 2 the heart of a leader
Lesson 2   the heart of a leaderLesson 2   the heart of a leader
Lesson 2 the heart of a leader
guevarra_2000
 
Lesson 9 computer systems hardware
Lesson 9   computer systems hardwareLesson 9   computer systems hardware
Lesson 9 computer systems hardware
guevarra_2000
 
Lesson 14 animating text and objects
Lesson 14   animating text and objectsLesson 14   animating text and objects
Lesson 14 animating text and objects
guevarra_2000
 
Lesson 9 word and arts shapes
Lesson 9   word and arts shapesLesson 9   word and arts shapes
Lesson 9 word and arts shapes
guevarra_2000
 
Lesson 1 setting up excel environment
Lesson 1   setting up excel environmentLesson 1   setting up excel environment
Lesson 1 setting up excel environment
guevarra_2000
 
Chap1 Business Ingeneral
Chap1 Business IngeneralChap1 Business Ingeneral
Chap1 Business Ingeneral
guevarra_2000
 
Lesson 10 computer systems hardware
Lesson 10 computer systems hardwareLesson 10 computer systems hardware
Lesson 10 computer systems hardware
guevarra_2000
 
Lesson 2 the heart of a leader
Lesson 2   the heart of a leaderLesson 2   the heart of a leader
Lesson 2 the heart of a leader
guevarra_2000
 
Lesson 9 computer systems hardware
Lesson 9   computer systems hardwareLesson 9   computer systems hardware
Lesson 9 computer systems hardware
guevarra_2000
 
Lesson 14 animating text and objects
Lesson 14   animating text and objectsLesson 14   animating text and objects
Lesson 14 animating text and objects
guevarra_2000
 
Lesson 9 word and arts shapes
Lesson 9   word and arts shapesLesson 9   word and arts shapes
Lesson 9 word and arts shapes
guevarra_2000
 
Ad

Similar to Lesson 10 working with charts (20)

MS Excel 2010 tutorial 6
MS Excel 2010 tutorial 6MS Excel 2010 tutorial 6
MS Excel 2010 tutorial 6
Khalfan Alshuaili
 
Microsoft Excel Tutorial
Microsoft Excel TutorialMicrosoft Excel Tutorial
Microsoft Excel Tutorial
Kristine Tiongco-Rimpa
 
Linking chart from excel with power point
Linking chart from excel with power pointLinking chart from excel with power point
Linking chart from excel with power point
SAMUEL BARNABAS IFITUMI
 
Excel Graphs Charts
Excel Graphs ChartsExcel Graphs Charts
Excel Graphs Charts
simply_coool
 
Basics of Creating Graphs / Charts using Microsoft Excel
Basics of Creating Graphs / Charts using Microsoft ExcelBasics of Creating Graphs / Charts using Microsoft Excel
Basics of Creating Graphs / Charts using Microsoft Excel
Tope Osanyintuyi
 
Computer midterms
Computer midtermsComputer midterms
Computer midterms
Emjei Mendoza
 
03 microsoft office (creating charts)
03 microsoft office (creating charts)03 microsoft office (creating charts)
03 microsoft office (creating charts)
benchhood
 
excell.pdf
excell.pdfexcell.pdf
excell.pdf
ssuser8f8817
 
Introduction to Excel
Introduction to ExcelIntroduction to Excel
Introduction to Excel
Najma Alam
 
Excel 2007 - Create a chart
Excel 2007 - Create a chartExcel 2007 - Create a chart
Excel 2007 - Create a chart
Oklahoma Dept. Mental Health
 
ms_excel.pdf
ms_excel.pdfms_excel.pdf
ms_excel.pdf
poonam256394
 
Excel training create a chart
Excel training create a chartExcel training create a chart
Excel training create a chart
Giovanni Alejandro
 
Excel 2007 create a chart
Excel 2007    create a chartExcel 2007    create a chart
Excel 2007 create a chart
rezaulslide
 
Excel 2007 create a chart
Excel 2007    create a chartExcel 2007    create a chart
Excel 2007 create a chart
khankamrul
 
Spreadsheets 2
Spreadsheets 2Spreadsheets 2
Spreadsheets 2
Jason Hando
 
4 4 making changes to graphs
4 4 making changes to graphs4 4 making changes to graphs
4 4 making changes to graphs
QondileRamokgadi
 
Exp2003 exl ppt_03
Exp2003 exl ppt_03Exp2003 exl ppt_03
Exp2003 exl ppt_03
lonetree
 
Creating charts and graphics
Creating charts and graphicsCreating charts and graphics
Creating charts and graphics
um5ashm
 
Advanced excel
Advanced excelAdvanced excel
Advanced excel
PremananthamM
 
Excel 2003 tutorial 2
Excel 2003 tutorial 2Excel 2003 tutorial 2
Excel 2003 tutorial 2
catacata1976
 
Linking chart from excel with power point
Linking chart from excel with power pointLinking chart from excel with power point
Linking chart from excel with power point
SAMUEL BARNABAS IFITUMI
 
Excel Graphs Charts
Excel Graphs ChartsExcel Graphs Charts
Excel Graphs Charts
simply_coool
 
Basics of Creating Graphs / Charts using Microsoft Excel
Basics of Creating Graphs / Charts using Microsoft ExcelBasics of Creating Graphs / Charts using Microsoft Excel
Basics of Creating Graphs / Charts using Microsoft Excel
Tope Osanyintuyi
 
03 microsoft office (creating charts)
03 microsoft office (creating charts)03 microsoft office (creating charts)
03 microsoft office (creating charts)
benchhood
 
Introduction to Excel
Introduction to ExcelIntroduction to Excel
Introduction to Excel
Najma Alam
 
Excel 2007 create a chart
Excel 2007    create a chartExcel 2007    create a chart
Excel 2007 create a chart
rezaulslide
 
Excel 2007 create a chart
Excel 2007    create a chartExcel 2007    create a chart
Excel 2007 create a chart
khankamrul
 
4 4 making changes to graphs
4 4 making changes to graphs4 4 making changes to graphs
4 4 making changes to graphs
QondileRamokgadi
 
Exp2003 exl ppt_03
Exp2003 exl ppt_03Exp2003 exl ppt_03
Exp2003 exl ppt_03
lonetree
 
Creating charts and graphics
Creating charts and graphicsCreating charts and graphics
Creating charts and graphics
um5ashm
 
Excel 2003 tutorial 2
Excel 2003 tutorial 2Excel 2003 tutorial 2
Excel 2003 tutorial 2
catacata1976
 
Ad

More from guevarra_2000 (20)

School personnel sheet2
School personnel sheet2School personnel sheet2
School personnel sheet2
guevarra_2000
 
Ting's report on training of spa
Ting's report on training of spaTing's report on training of spa
Ting's report on training of spa
guevarra_2000
 
Personnel admin
Personnel adminPersonnel admin
Personnel admin
guevarra_2000
 
Personnel administration
Personnel administrationPersonnel administration
Personnel administration
guevarra_2000
 
Supervisor's role
Supervisor's roleSupervisor's role
Supervisor's role
guevarra_2000
 
Filipino values and culture
Filipino values and cultureFilipino values and culture
Filipino values and culture
guevarra_2000
 
Format for the action research project
Format for the action research projectFormat for the action research project
Format for the action research project
guevarra_2000
 
Course outline
Course outlineCourse outline
Course outline
guevarra_2000
 
Course outline
Course outlineCourse outline
Course outline
guevarra_2000
 
Action research format
Action research formatAction research format
Action research format
guevarra_2000
 
Recruitment
RecruitmentRecruitment
Recruitment
guevarra_2000
 
Recruitmentcompatible 1222798911739370-9
Recruitmentcompatible 1222798911739370-9Recruitmentcompatible 1222798911739370-9
Recruitmentcompatible 1222798911739370-9
guevarra_2000
 
Filipino culture report
Filipino culture reportFilipino culture report
Filipino culture report
guevarra_2000
 
Personnel administration report
Personnel administration reportPersonnel administration report
Personnel administration report
guevarra_2000
 
Leader&cultural diversity
Leader&cultural diversityLeader&cultural diversity
Leader&cultural diversity
guevarra_2000
 
Leader&cultural diversity
Leader&cultural diversityLeader&cultural diversity
Leader&cultural diversity
guevarra_2000
 
Edleadership
EdleadershipEdleadership
Edleadership
guevarra_2000
 
Principles of getting job done
Principles of getting job donePrinciples of getting job done
Principles of getting job done
guevarra_2000
 
Leading different personalities
Leading different personalitiesLeading different personalities
Leading different personalities
guevarra_2000
 
Success2012
Success2012Success2012
Success2012
guevarra_2000
 
School personnel sheet2
School personnel sheet2School personnel sheet2
School personnel sheet2
guevarra_2000
 
Ting's report on training of spa
Ting's report on training of spaTing's report on training of spa
Ting's report on training of spa
guevarra_2000
 
Personnel administration
Personnel administrationPersonnel administration
Personnel administration
guevarra_2000
 
Filipino values and culture
Filipino values and cultureFilipino values and culture
Filipino values and culture
guevarra_2000
 
Format for the action research project
Format for the action research projectFormat for the action research project
Format for the action research project
guevarra_2000
 
Action research format
Action research formatAction research format
Action research format
guevarra_2000
 
Recruitmentcompatible 1222798911739370-9
Recruitmentcompatible 1222798911739370-9Recruitmentcompatible 1222798911739370-9
Recruitmentcompatible 1222798911739370-9
guevarra_2000
 
Filipino culture report
Filipino culture reportFilipino culture report
Filipino culture report
guevarra_2000
 
Personnel administration report
Personnel administration reportPersonnel administration report
Personnel administration report
guevarra_2000
 
Leader&cultural diversity
Leader&cultural diversityLeader&cultural diversity
Leader&cultural diversity
guevarra_2000
 
Leader&cultural diversity
Leader&cultural diversityLeader&cultural diversity
Leader&cultural diversity
guevarra_2000
 
Principles of getting job done
Principles of getting job donePrinciples of getting job done
Principles of getting job done
guevarra_2000
 
Leading different personalities
Leading different personalitiesLeading different personalities
Leading different personalities
guevarra_2000
 

Recently uploaded (20)

Design pattern talk by Kaya Weers - 2025 (v2)
Design pattern talk by Kaya Weers - 2025 (v2)Design pattern talk by Kaya Weers - 2025 (v2)
Design pattern talk by Kaya Weers - 2025 (v2)
Kaya Weers
 
Challenges in Migrating Imperative Deep Learning Programs to Graph Execution:...
Challenges in Migrating Imperative Deep Learning Programs to Graph Execution:...Challenges in Migrating Imperative Deep Learning Programs to Graph Execution:...
Challenges in Migrating Imperative Deep Learning Programs to Graph Execution:...
Raffi Khatchadourian
 
AI x Accessibility UXPA by Stew Smith and Olivier Vroom
AI x Accessibility UXPA by Stew Smith and Olivier VroomAI x Accessibility UXPA by Stew Smith and Olivier Vroom
AI x Accessibility UXPA by Stew Smith and Olivier Vroom
UXPA Boston
 
On-Device or Remote? On the Energy Efficiency of Fetching LLM-Generated Conte...
On-Device or Remote? On the Energy Efficiency of Fetching LLM-Generated Conte...On-Device or Remote? On the Energy Efficiency of Fetching LLM-Generated Conte...
On-Device or Remote? On the Energy Efficiency of Fetching LLM-Generated Conte...
Ivano Malavolta
 
IT484 Cyber Forensics_Information Technology
IT484 Cyber Forensics_Information TechnologyIT484 Cyber Forensics_Information Technology
IT484 Cyber Forensics_Information Technology
SHEHABALYAMANI
 
Reimagine How You and Your Team Work with Microsoft 365 Copilot.pptx
Reimagine How You and Your Team Work with Microsoft 365 Copilot.pptxReimagine How You and Your Team Work with Microsoft 365 Copilot.pptx
Reimagine How You and Your Team Work with Microsoft 365 Copilot.pptx
John Moore
 
An Overview of Salesforce Health Cloud & How is it Transforming Patient Care
An Overview of Salesforce Health Cloud & How is it Transforming Patient CareAn Overview of Salesforce Health Cloud & How is it Transforming Patient Care
An Overview of Salesforce Health Cloud & How is it Transforming Patient Care
Cyntexa
 
Bepents tech services - a premier cybersecurity consulting firm
Bepents tech services - a premier cybersecurity consulting firmBepents tech services - a premier cybersecurity consulting firm
Bepents tech services - a premier cybersecurity consulting firm
Benard76
 
Crazy Incentives and How They Kill Security. How Do You Turn the Wheel?
Crazy Incentives and How They Kill Security. How Do You Turn the Wheel?Crazy Incentives and How They Kill Security. How Do You Turn the Wheel?
Crazy Incentives and How They Kill Security. How Do You Turn the Wheel?
Christian Folini
 
Dark Dynamism: drones, dark factories and deurbanization
Dark Dynamism: drones, dark factories and deurbanizationDark Dynamism: drones, dark factories and deurbanization
Dark Dynamism: drones, dark factories and deurbanization
Jakub Šimek
 
Slack like a pro: strategies for 10x engineering teams
Slack like a pro: strategies for 10x engineering teamsSlack like a pro: strategies for 10x engineering teams
Slack like a pro: strategies for 10x engineering teams
Nacho Cougil
 
Everything You Need to Know About Agentforce? (Put AI Agents to Work)
Everything You Need to Know About Agentforce? (Put AI Agents to Work)Everything You Need to Know About Agentforce? (Put AI Agents to Work)
Everything You Need to Know About Agentforce? (Put AI Agents to Work)
Cyntexa
 
DevOpsDays SLC - Platform Engineers are Product Managers.pptx
DevOpsDays SLC - Platform Engineers are Product Managers.pptxDevOpsDays SLC - Platform Engineers are Product Managers.pptx
DevOpsDays SLC - Platform Engineers are Product Managers.pptx
Justin Reock
 
GDG Cloud Southlake #42: Suresh Mathew: Autonomous Resource Optimization: How...
GDG Cloud Southlake #42: Suresh Mathew: Autonomous Resource Optimization: How...GDG Cloud Southlake #42: Suresh Mathew: Autonomous Resource Optimization: How...
GDG Cloud Southlake #42: Suresh Mathew: Autonomous Resource Optimization: How...
James Anderson
 
Viam product demo_ Deploying and scaling AI with hardware.pdf
Viam product demo_ Deploying and scaling AI with hardware.pdfViam product demo_ Deploying and scaling AI with hardware.pdf
Viam product demo_ Deploying and scaling AI with hardware.pdf
camilalamoratta
 
Zilliz Cloud Monthly Technical Review: May 2025
Zilliz Cloud Monthly Technical Review: May 2025Zilliz Cloud Monthly Technical Review: May 2025
Zilliz Cloud Monthly Technical Review: May 2025
Zilliz
 
Agentic Automation - Delhi UiPath Community Meetup
Agentic Automation - Delhi UiPath Community MeetupAgentic Automation - Delhi UiPath Community Meetup
Agentic Automation - Delhi UiPath Community Meetup
Manoj Batra (1600 + Connections)
 
Shoehorning dependency injection into a FP language, what does it take?
Shoehorning dependency injection into a FP language, what does it take?Shoehorning dependency injection into a FP language, what does it take?
Shoehorning dependency injection into a FP language, what does it take?
Eric Torreborre
 
AI Agents at Work: UiPath, Maestro & the Future of Documents
AI Agents at Work: UiPath, Maestro & the Future of DocumentsAI Agents at Work: UiPath, Maestro & the Future of Documents
AI Agents at Work: UiPath, Maestro & the Future of Documents
UiPathCommunity
 
Build With AI - In Person Session Slides.pdf
Build With AI - In Person Session Slides.pdfBuild With AI - In Person Session Slides.pdf
Build With AI - In Person Session Slides.pdf
Google Developer Group - Harare
 
Design pattern talk by Kaya Weers - 2025 (v2)
Design pattern talk by Kaya Weers - 2025 (v2)Design pattern talk by Kaya Weers - 2025 (v2)
Design pattern talk by Kaya Weers - 2025 (v2)
Kaya Weers
 
Challenges in Migrating Imperative Deep Learning Programs to Graph Execution:...
Challenges in Migrating Imperative Deep Learning Programs to Graph Execution:...Challenges in Migrating Imperative Deep Learning Programs to Graph Execution:...
Challenges in Migrating Imperative Deep Learning Programs to Graph Execution:...
Raffi Khatchadourian
 
AI x Accessibility UXPA by Stew Smith and Olivier Vroom
AI x Accessibility UXPA by Stew Smith and Olivier VroomAI x Accessibility UXPA by Stew Smith and Olivier Vroom
AI x Accessibility UXPA by Stew Smith and Olivier Vroom
UXPA Boston
 
On-Device or Remote? On the Energy Efficiency of Fetching LLM-Generated Conte...
On-Device or Remote? On the Energy Efficiency of Fetching LLM-Generated Conte...On-Device or Remote? On the Energy Efficiency of Fetching LLM-Generated Conte...
On-Device or Remote? On the Energy Efficiency of Fetching LLM-Generated Conte...
Ivano Malavolta
 
IT484 Cyber Forensics_Information Technology
IT484 Cyber Forensics_Information TechnologyIT484 Cyber Forensics_Information Technology
IT484 Cyber Forensics_Information Technology
SHEHABALYAMANI
 
Reimagine How You and Your Team Work with Microsoft 365 Copilot.pptx
Reimagine How You and Your Team Work with Microsoft 365 Copilot.pptxReimagine How You and Your Team Work with Microsoft 365 Copilot.pptx
Reimagine How You and Your Team Work with Microsoft 365 Copilot.pptx
John Moore
 
An Overview of Salesforce Health Cloud & How is it Transforming Patient Care
An Overview of Salesforce Health Cloud & How is it Transforming Patient CareAn Overview of Salesforce Health Cloud & How is it Transforming Patient Care
An Overview of Salesforce Health Cloud & How is it Transforming Patient Care
Cyntexa
 
Bepents tech services - a premier cybersecurity consulting firm
Bepents tech services - a premier cybersecurity consulting firmBepents tech services - a premier cybersecurity consulting firm
Bepents tech services - a premier cybersecurity consulting firm
Benard76
 
Crazy Incentives and How They Kill Security. How Do You Turn the Wheel?
Crazy Incentives and How They Kill Security. How Do You Turn the Wheel?Crazy Incentives and How They Kill Security. How Do You Turn the Wheel?
Crazy Incentives and How They Kill Security. How Do You Turn the Wheel?
Christian Folini
 
Dark Dynamism: drones, dark factories and deurbanization
Dark Dynamism: drones, dark factories and deurbanizationDark Dynamism: drones, dark factories and deurbanization
Dark Dynamism: drones, dark factories and deurbanization
Jakub Šimek
 
Slack like a pro: strategies for 10x engineering teams
Slack like a pro: strategies for 10x engineering teamsSlack like a pro: strategies for 10x engineering teams
Slack like a pro: strategies for 10x engineering teams
Nacho Cougil
 
Everything You Need to Know About Agentforce? (Put AI Agents to Work)
Everything You Need to Know About Agentforce? (Put AI Agents to Work)Everything You Need to Know About Agentforce? (Put AI Agents to Work)
Everything You Need to Know About Agentforce? (Put AI Agents to Work)
Cyntexa
 
DevOpsDays SLC - Platform Engineers are Product Managers.pptx
DevOpsDays SLC - Platform Engineers are Product Managers.pptxDevOpsDays SLC - Platform Engineers are Product Managers.pptx
DevOpsDays SLC - Platform Engineers are Product Managers.pptx
Justin Reock
 
GDG Cloud Southlake #42: Suresh Mathew: Autonomous Resource Optimization: How...
GDG Cloud Southlake #42: Suresh Mathew: Autonomous Resource Optimization: How...GDG Cloud Southlake #42: Suresh Mathew: Autonomous Resource Optimization: How...
GDG Cloud Southlake #42: Suresh Mathew: Autonomous Resource Optimization: How...
James Anderson
 
Viam product demo_ Deploying and scaling AI with hardware.pdf
Viam product demo_ Deploying and scaling AI with hardware.pdfViam product demo_ Deploying and scaling AI with hardware.pdf
Viam product demo_ Deploying and scaling AI with hardware.pdf
camilalamoratta
 
Zilliz Cloud Monthly Technical Review: May 2025
Zilliz Cloud Monthly Technical Review: May 2025Zilliz Cloud Monthly Technical Review: May 2025
Zilliz Cloud Monthly Technical Review: May 2025
Zilliz
 
Shoehorning dependency injection into a FP language, what does it take?
Shoehorning dependency injection into a FP language, what does it take?Shoehorning dependency injection into a FP language, what does it take?
Shoehorning dependency injection into a FP language, what does it take?
Eric Torreborre
 
AI Agents at Work: UiPath, Maestro & the Future of Documents
AI Agents at Work: UiPath, Maestro & the Future of DocumentsAI Agents at Work: UiPath, Maestro & the Future of Documents
AI Agents at Work: UiPath, Maestro & the Future of Documents
UiPathCommunity
 

Lesson 10 working with charts

  • 2. A chart is a tool you can use to communicate your data graphically. Charts often help an audience to see the meaning behind numbers and make showing comparisons and trends easy. In this lesson, you will learn how to insert and modify charts and see how they can be an effective tool for communicating information.
  • 3. To Insert a Chart:Select the Insert tab.Click the Insert Chart command. The Insert Chart dialog box appears.
  • 4. Click and drag the scroll bar to view the chart types, or click a label on the left of the dialog box to see a specific chart style.
  • 5. Click a chart to select it.Click OK. Excel will open. Usually, Excel will appear on one side of the screen, while PowerPoint appears on the other side of the screen.If a slide layout has a content placeholder, click the Insert Chart command to insert a new chart
  • 6. Enter Chart DataThe data that appears in the Excel spreadsheet is placeholder source data that you will replace with your own information. The Excel source data is used to create the PowerPoint chart.
  • 7. To Enter Chart Data:Select a cell in the Excel spreadsheet.Enter your data in the cell. If the cell contains placeholder data, the placeholder data will disappear. As you enter your data, it will appear in the Excel spreadsheet and the PowerPoint chart.Move to another cell.Repeat the above steps until all your data is entered.
  • 8. Click and drag the lower-right corner of the blue line to increase or decrease the data range for columns. The data enclosed by the blue lines will appear in the chart.Click and drag the lower-right corner of the blue line to increase or decrease the data range for rows
  • 9. Select any cells with placeholder data remaining. In the example, the column with Series 3 data was not needed.
  • 10. Press the Delete key to delete the remaining placeholder data.Close Excel. You do not need to save the spreadsheet. The new Excel source data appears in the PowerPoint chart.
  • 11. Formatting ChartsWhen you insert a chart, three new tabs will appear on the Ribbon. The three tabs -- Design, Layout, and Format -- contain various chart tools and commands that allow you to modify and format the chart.
  • 12. To Change the Chart Type:Select the chart.Select the Design tab.Click the Change Chart Type command. The Insert Chart dialog box will appear.
  • 13. Select the chart you would like.Click OK. The chart will change on the slide to the new chart type.
  • 14. To Edit Source Data:Select the chart.Select the Design tab.Click the Edit Data command. An Excel spreadsheet with the current source data will appear.Edit the data in the spreadsheet. The changes will appear on the slide.Close Excel without saving the spreadsheet.
  • 15. To Change the Chart Style:Select the chart.Select the Design tab.Scroll through the options in the Chart Style group, or click the More drop-down arrow to see all the chart style options.
  • 16. Click a chart style to select it. The chart style will change on the slide.
  • 18. Source DataThe range of cells that make up a chart. The chart is updated automatically whenever the information in these cells change.TitleThe title of the chart.LegendThe chart key, which identifies what each color on the chart represents.AxisThe vertical and horizontal parts of a chart. The vertical axis is often referred to as the Y axis, and the horizontal axis is referred to as the X axis.
  • 19. To Change the Chart Layout:Select the chart.Select the Design tab.Scroll through the options in the Chart Layout group, or click the More drop-down arrow to see all the chart layout options.Click a chart layout to select it. The chart layout will change on the slide.The chart layout determines how specific chart information will appear. For example, some layouts include chart titles, legends, and axis labelsTo Modify Specific Areas of the Chart LayoutSelect the chart.Select the Layout tab.Locate the Labels group.
  • 20. Chart Titles:Click this command to remove or add a chart title.
  • 21. Axis TitleClick this command and choose to hide or display the horizontal, or x axis, label; hide or display the vertical, or y axis, labels; and change the direction of the axis labels to horizontal or vertical.
  • 22. LegendClick this command to select a location for the legend to appear, or choose to not display a legend.
  • 23. Data LabelsClick this command to display or hide data values next to each chart element.
  • 24. Other Important Commands on the Layout TabIn the Axes group, there are several commands that control both axes and whether the gridlines are visible. In the Background group, there are several commands that control the visual aspects of the chart. Some commands in the Analysis group will appear active only if the selected chart is a line, area, or bubble chart.
  • 25. Additional Chart FormattingUse the commands on the Format tab to modify the chart in additional ways. For example, from this tab you can change the chart outline, format chart text as WordArt, and more.
  • 26. ChallengeUse the Company Overview presentation or any other PowerPoint presentation you choose to complete this challenge.Open a presentation.Insert a bar chart.Change the chart to a line chart.Change the chart layout.Apply a different chart style.Add axis labels if they are not included on the layout you chose.
  翻译: