SlideShare a Scribd company logo
In this video, you will learn to
• Gather data from
surveymonkey.com
• Create a graph in Microsoft Excel
• Paste your graph into Microsoft
Word
Feel free to pause, rewind, or rewatch this video.
I’ve created my survey and am still on the “Design Survey” tab.
In order to allow people to take my survey, I click on the
button “Collect Response.”
Then, I choose “Web Link” and copy the link that pops up. This is
the link I will share with my peers on the discussion board.
Once I’ve collected responses from my audience (my peers), I can
look at the results by clicking on the “Analyze Results” tab.
Then, I get a really cool graph, but unfortunately, I can’t copy and
paste it. So I’ll have to make my own.
When I scroll
down the page, I
get the number of
responses for
each choice.
Even though I am
offered a
percentile, I am
going to use the
actual number of
responses
instead.
Now, I open a new document in Excel and enter my data. Do NOT
include blank cells in your data because it will mess up your
graph when you make it. Just cram everything together like I
have. It doesn’t have to look pretty.
Highlight your data. Do not highlight any empty cells. Then, click
on the “Charts” tab. Finally, choose the kind of graph you want to
make.
I have chosen a
column chart,
more
specifically the
“Clustered
Column” chart.
Now I have a nice little graph! But it needs improvements.
Warning: You have to click on your chart in order to modify it. If
you click outside the chart, you will lose the option to modify it.
Just click back on it again.
First I want to get rid of the legend on the side since it is not
conveying any useful information. So I just click on it and press
either “Delete” or “Backspace” on my keyboard.
I also want to modify my title since it has the word “Number” in
it for some reason. I just click on the title and make changes.
I also want to give more information about what my data
means, so I want to add a title to the horizontal axis and the
vertical axis. I click on the “Chart Layout” tab and then on the
“Axis Titles” tab.
Now I can give my graph a horizontal title…
…and a vertical title.
This is what my graph looks like now. But I’m not quite
finished.
I want to place the value above each line of the bar chart, so I’m
going to go back to the “Chart Layout” tab, click on “Data
Labels,” and choose “Value” (not shown).
Now I have a gorgeous chart to put in my paper!
Adding my chart to my paper is very easy. I just click on the
chart and then copy it.
Then, I open a new Word document and paste it in.
Underneath, be sure to give your graph a title.
To make your graph easier to move around, click on the graph itself.
Then, choose the “Format” tab that pops up, “Wrap Text,” and “Top
and Bottom” (not shown).
That’s the end of this tutorial. I hope you
found it helpful.
Ad

More Related Content

What's hot (20)

Designstorm How-to: Dot Plots
Designstorm How-to: Dot PlotsDesignstorm How-to: Dot Plots
Designstorm How-to: Dot Plots
Amanda Makulec
 
Graphing Using Excel Part Ii 2008 Finished
Graphing Using Excel Part Ii 2008 FinishedGraphing Using Excel Part Ii 2008 Finished
Graphing Using Excel Part Ii 2008 Finished
Stephanie
 
Lesson11 working with charts
Lesson11 working with chartsLesson11 working with charts
Lesson11 working with charts
ricsanmae
 
Lesson 16 Working With Charts
Lesson 16   Working With ChartsLesson 16   Working With Charts
Lesson 16 Working With Charts
guevarra_2000
 
Tutorial of microsoft excel 2007
Tutorial of microsoft excel 2007Tutorial of microsoft excel 2007
Tutorial of microsoft excel 2007
sabillafh
 
Microsoft Excel 101
Microsoft Excel 101Microsoft Excel 101
Microsoft Excel 101
Louis Honeyman
 
Charts in excel 2007
Charts in excel 2007Charts in excel 2007
Charts in excel 2007
bloftinsaisd
 
Print16
Print16Print16
Print16
Hassan Samoon
 
How to make a conditional column chart in Excel
How to make a conditional column chart in ExcelHow to make a conditional column chart in Excel
How to make a conditional column chart in Excel
SteveEqualsTrue
 
Microsoft Excel 2013 Basics course
Microsoft Excel 2013 Basics courseMicrosoft Excel 2013 Basics course
Microsoft Excel 2013 Basics course
Muhammad Shakir
 
Lesson 11 working with charts
Lesson 11   working with chartsLesson 11   working with charts
Lesson 11 working with charts
guevarra_2000
 
Excel 2016 top features
Excel 2016 top featuresExcel 2016 top features
Excel 2016 top features
Bandhu P. Das
 
Creating & Editing Charts In Microsoft Excel 2003
Creating & Editing Charts In Microsoft Excel 2003Creating & Editing Charts In Microsoft Excel 2003
Creating & Editing Charts In Microsoft Excel 2003
bud_00
 
Microsoft Excel Basics
Microsoft Excel BasicsMicrosoft Excel Basics
Microsoft Excel Basics
Compudon
 
Functions and formulas of ms excel
Functions and formulas of ms excelFunctions and formulas of ms excel
Functions and formulas of ms excel
madhuparna bhowmik
 
How to make your own population pyramid in six simple steps
How to make your own population pyramid in six simple stepsHow to make your own population pyramid in six simple steps
How to make your own population pyramid in six simple steps
Ned Baring
 
Basic tasks in excel 2013
Basic tasks in excel 2013Basic tasks in excel 2013
Basic tasks in excel 2013
karlagabriela1995
 
Creating a chart in Excel
Creating a chart in Excel Creating a chart in Excel
Creating a chart in Excel
JessicaCheung1998
 
Tutorial for chart design in MS Excel 2007
Tutorial for chart design in MS Excel 2007Tutorial for chart design in MS Excel 2007
Tutorial for chart design in MS Excel 2007
slavicivan
 
MS Excel Ch 1 PPT
MS Excel Ch 1 PPTMS Excel Ch 1 PPT
MS Excel Ch 1 PPT
prsmith72
 
Designstorm How-to: Dot Plots
Designstorm How-to: Dot PlotsDesignstorm How-to: Dot Plots
Designstorm How-to: Dot Plots
Amanda Makulec
 
Graphing Using Excel Part Ii 2008 Finished
Graphing Using Excel Part Ii 2008 FinishedGraphing Using Excel Part Ii 2008 Finished
Graphing Using Excel Part Ii 2008 Finished
Stephanie
 
Lesson11 working with charts
Lesson11 working with chartsLesson11 working with charts
Lesson11 working with charts
ricsanmae
 
Lesson 16 Working With Charts
Lesson 16   Working With ChartsLesson 16   Working With Charts
Lesson 16 Working With Charts
guevarra_2000
 
Tutorial of microsoft excel 2007
Tutorial of microsoft excel 2007Tutorial of microsoft excel 2007
Tutorial of microsoft excel 2007
sabillafh
 
Charts in excel 2007
Charts in excel 2007Charts in excel 2007
Charts in excel 2007
bloftinsaisd
 
How to make a conditional column chart in Excel
How to make a conditional column chart in ExcelHow to make a conditional column chart in Excel
How to make a conditional column chart in Excel
SteveEqualsTrue
 
Microsoft Excel 2013 Basics course
Microsoft Excel 2013 Basics courseMicrosoft Excel 2013 Basics course
Microsoft Excel 2013 Basics course
Muhammad Shakir
 
Lesson 11 working with charts
Lesson 11   working with chartsLesson 11   working with charts
Lesson 11 working with charts
guevarra_2000
 
Excel 2016 top features
Excel 2016 top featuresExcel 2016 top features
Excel 2016 top features
Bandhu P. Das
 
Creating & Editing Charts In Microsoft Excel 2003
Creating & Editing Charts In Microsoft Excel 2003Creating & Editing Charts In Microsoft Excel 2003
Creating & Editing Charts In Microsoft Excel 2003
bud_00
 
Microsoft Excel Basics
Microsoft Excel BasicsMicrosoft Excel Basics
Microsoft Excel Basics
Compudon
 
Functions and formulas of ms excel
Functions and formulas of ms excelFunctions and formulas of ms excel
Functions and formulas of ms excel
madhuparna bhowmik
 
How to make your own population pyramid in six simple steps
How to make your own population pyramid in six simple stepsHow to make your own population pyramid in six simple steps
How to make your own population pyramid in six simple steps
Ned Baring
 
Tutorial for chart design in MS Excel 2007
Tutorial for chart design in MS Excel 2007Tutorial for chart design in MS Excel 2007
Tutorial for chart design in MS Excel 2007
slavicivan
 
MS Excel Ch 1 PPT
MS Excel Ch 1 PPTMS Excel Ch 1 PPT
MS Excel Ch 1 PPT
prsmith72
 

Viewers also liked (14)

4th grade daily schedule
4th grade daily schedule4th grade daily schedule
4th grade daily schedule
nawrota
 
Práctica excel filtros, encabezado
Práctica excel   filtros, encabezadoPráctica excel   filtros, encabezado
Práctica excel filtros, encabezado
JACIERCAS
 
Lopez marco ..... vision
Lopez marco ..... visionLopez marco ..... vision
Lopez marco ..... vision
Marco Lopez
 
ACES Office of Research Int. presentation
ACES Office of Research Int. presentationACES Office of Research Int. presentation
ACES Office of Research Int. presentation
Meghana Srinivasan
 
Motraclinde materials handling World 2016 frankfurt
Motraclinde materials handling World  2016 frankfurtMotraclinde materials handling World  2016 frankfurt
Motraclinde materials handling World 2016 frankfurt
Vincent Everts
 
2016 ETF and investment outlook
2016 ETF and investment outlook2016 ETF and investment outlook
2016 ETF and investment outlook
Ying wei (Joe) Chou
 
Características Pc
Características PcCaracterísticas Pc
Características Pc
JonatanTd
 
Atención a la diversidad
Atención a la diversidadAtención a la diversidad
Atención a la diversidad
Anela Mendoza
 
《网易网站及相关产品设计规范》杨烽亮
《网易网站及相关产品设计规范》杨烽亮《网易网站及相关产品设计规范》杨烽亮
《网易网站及相关产品设计规范》杨烽亮
top idea
 
Descripcions ninots
Descripcions ninotsDescripcions ninots
Descripcions ninots
Anni Melià Pascual
 
Demonetization: A Welcome or a Worry
Demonetization: A Welcome or a WorryDemonetization: A Welcome or a Worry
Demonetization: A Welcome or a Worry
Mehul Shah
 
Khu biệt thự biển - Orchard villas resort - Phan Thiết
Khu biệt thự biển - Orchard villas resort - Phan ThiếtKhu biệt thự biển - Orchard villas resort - Phan Thiết
Khu biệt thự biển - Orchard villas resort - Phan Thiết
Cody Trọng
 
Flexible Packaging online DIY 好In網529 Inprint123
Flexible Packaging online DIY 好In網529 Inprint123 Flexible Packaging online DIY 好In網529 Inprint123
Flexible Packaging online DIY 好In網529 Inprint123
Donna Chiang
 
4th grade daily schedule
4th grade daily schedule4th grade daily schedule
4th grade daily schedule
nawrota
 
Práctica excel filtros, encabezado
Práctica excel   filtros, encabezadoPráctica excel   filtros, encabezado
Práctica excel filtros, encabezado
JACIERCAS
 
Lopez marco ..... vision
Lopez marco ..... visionLopez marco ..... vision
Lopez marco ..... vision
Marco Lopez
 
ACES Office of Research Int. presentation
ACES Office of Research Int. presentationACES Office of Research Int. presentation
ACES Office of Research Int. presentation
Meghana Srinivasan
 
Motraclinde materials handling World 2016 frankfurt
Motraclinde materials handling World  2016 frankfurtMotraclinde materials handling World  2016 frankfurt
Motraclinde materials handling World 2016 frankfurt
Vincent Everts
 
Características Pc
Características PcCaracterísticas Pc
Características Pc
JonatanTd
 
Atención a la diversidad
Atención a la diversidadAtención a la diversidad
Atención a la diversidad
Anela Mendoza
 
《网易网站及相关产品设计规范》杨烽亮
《网易网站及相关产品设计规范》杨烽亮《网易网站及相关产品设计规范》杨烽亮
《网易网站及相关产品设计规范》杨烽亮
top idea
 
Demonetization: A Welcome or a Worry
Demonetization: A Welcome or a WorryDemonetization: A Welcome or a Worry
Demonetization: A Welcome or a Worry
Mehul Shah
 
Khu biệt thự biển - Orchard villas resort - Phan Thiết
Khu biệt thự biển - Orchard villas resort - Phan ThiếtKhu biệt thự biển - Orchard villas resort - Phan Thiết
Khu biệt thự biển - Orchard villas resort - Phan Thiết
Cody Trọng
 
Flexible Packaging online DIY 好In網529 Inprint123
Flexible Packaging online DIY 好In網529 Inprint123 Flexible Packaging online DIY 好In網529 Inprint123
Flexible Packaging online DIY 好In網529 Inprint123
Donna Chiang
 
Ad

Similar to Creating graphs in excel (20)

Advanced Models
Advanced ModelsAdvanced Models
Advanced Models
Tom Loughran
 
L14 chanp
L14 chanpL14 chanp
L14 chanp
LunarChad
 
How to - Edit the Settings and Layout on Netvibes
How to - Edit the Settings and Layout on NetvibesHow to - Edit the Settings and Layout on Netvibes
How to - Edit the Settings and Layout on Netvibes
mmoore17
 
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
 
ms_excel.pdf
ms_excel.pdfms_excel.pdf
ms_excel.pdf
poonam256394
 
Floating column chart
Floating column chartFloating column chart
Floating column chart
Daksha Bhat
 
Making a Pie Chart
Making a Pie ChartMaking a Pie Chart
Making a Pie Chart
Daksha Bhat
 
Graphics
GraphicsGraphics
Graphics
Buffalo Seminary
 
Office 365 Productivity Tips -- Mayhem in Minneapolis
Office 365 Productivity Tips -- Mayhem in MinneapolisOffice 365 Productivity Tips -- Mayhem in Minneapolis
Office 365 Productivity Tips -- Mayhem in Minneapolis
Christian Buckley
 
Office 365 Productivity Tips Minneapolis Mayhem SPSTC
Office 365 Productivity Tips Minneapolis Mayhem SPSTCOffice 365 Productivity Tips Minneapolis Mayhem SPSTC
Office 365 Productivity Tips Minneapolis Mayhem SPSTC
Thomas Duff
 
Lesson 10 working with charts
Lesson 10   working with chartsLesson 10   working with charts
Lesson 10 working with charts
guevarra_2000
 
PowerPoint Ideas & Hacks: Data
PowerPoint Ideas & Hacks: DataPowerPoint Ideas & Hacks: Data
PowerPoint Ideas & Hacks: Data
Ashleigh Cote, CMP
 
Excel Crash Course: Pivot Tables
Excel Crash Course: Pivot TablesExcel Crash Course: Pivot Tables
Excel Crash Course: Pivot Tables
Bobby Jones
 
04 ms excel
04 ms excel04 ms excel
04 ms excel
fosterstac
 
Microsoft Excel Seminar
Microsoft Excel SeminarMicrosoft Excel Seminar
Microsoft Excel Seminar
Meridian Career Institute
 
Microsoft Office PowerPoint 2007 - Lesson 4
Microsoft Office PowerPoint 2007 - Lesson 4Microsoft Office PowerPoint 2007 - Lesson 4
Microsoft Office PowerPoint 2007 - Lesson 4
Samantha TerBeest
 
Chapter.07
Chapter.07Chapter.07
Chapter.07
klivsie
 
Chapter 7 - Finalizing a Worksheet
Chapter 7 - Finalizing a WorksheetChapter 7 - Finalizing a Worksheet
Chapter 7 - Finalizing a Worksheet
Beverly Murphy
 
Chapter.07
Chapter.07Chapter.07
Chapter.07
jdswitzer
 
How to - Edit the Settings and Layout on Netvibes
How to - Edit the Settings and Layout on NetvibesHow to - Edit the Settings and Layout on Netvibes
How to - Edit the Settings and Layout on Netvibes
mmoore17
 
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
 
Floating column chart
Floating column chartFloating column chart
Floating column chart
Daksha Bhat
 
Making a Pie Chart
Making a Pie ChartMaking a Pie Chart
Making a Pie Chart
Daksha Bhat
 
Office 365 Productivity Tips -- Mayhem in Minneapolis
Office 365 Productivity Tips -- Mayhem in MinneapolisOffice 365 Productivity Tips -- Mayhem in Minneapolis
Office 365 Productivity Tips -- Mayhem in Minneapolis
Christian Buckley
 
Office 365 Productivity Tips Minneapolis Mayhem SPSTC
Office 365 Productivity Tips Minneapolis Mayhem SPSTCOffice 365 Productivity Tips Minneapolis Mayhem SPSTC
Office 365 Productivity Tips Minneapolis Mayhem SPSTC
Thomas Duff
 
Lesson 10 working with charts
Lesson 10   working with chartsLesson 10   working with charts
Lesson 10 working with charts
guevarra_2000
 
PowerPoint Ideas & Hacks: Data
PowerPoint Ideas & Hacks: DataPowerPoint Ideas & Hacks: Data
PowerPoint Ideas & Hacks: Data
Ashleigh Cote, CMP
 
Excel Crash Course: Pivot Tables
Excel Crash Course: Pivot TablesExcel Crash Course: Pivot Tables
Excel Crash Course: Pivot Tables
Bobby Jones
 
Microsoft Office PowerPoint 2007 - Lesson 4
Microsoft Office PowerPoint 2007 - Lesson 4Microsoft Office PowerPoint 2007 - Lesson 4
Microsoft Office PowerPoint 2007 - Lesson 4
Samantha TerBeest
 
Chapter.07
Chapter.07Chapter.07
Chapter.07
klivsie
 
Chapter 7 - Finalizing a Worksheet
Chapter 7 - Finalizing a WorksheetChapter 7 - Finalizing a Worksheet
Chapter 7 - Finalizing a Worksheet
Beverly Murphy
 
Ad

More from clynnc (18)

Sample rhetorical analysis
Sample rhetorical analysisSample rhetorical analysis
Sample rhetorical analysis
clynnc
 
Quiz show inductive & deductive reasoning
Quiz show inductive & deductive reasoningQuiz show inductive & deductive reasoning
Quiz show inductive & deductive reasoning
clynnc
 
Peer assessment instructions
Peer assessment instructionsPeer assessment instructions
Peer assessment instructions
clynnc
 
Start here
Start hereStart here
Start here
clynnc
 
Rhetorical analysis assignment brainstorming
Rhetorical analysis assignment brainstormingRhetorical analysis assignment brainstorming
Rhetorical analysis assignment brainstorming
clynnc
 
Mla format 2
Mla format 2Mla format 2
Mla format 2
clynnc
 
Creating Graphs in Excel
Creating Graphs in ExcelCreating Graphs in Excel
Creating Graphs in Excel
clynnc
 
Brainstorming questions
Brainstorming questionsBrainstorming questions
Brainstorming questions
clynnc
 
Ethos pathos logos
Ethos pathos logosEthos pathos logos
Ethos pathos logos
clynnc
 
Research strategies
Research strategiesResearch strategies
Research strategies
clynnc
 
Research strategies
Research strategiesResearch strategies
Research strategies
clynnc
 
Mla format 2
Mla format 2Mla format 2
Mla format 2
clynnc
 
MLA Format 1
MLA Format 1MLA Format 1
MLA Format 1
clynnc
 
Collaborative document tips
Collaborative document tipsCollaborative document tips
Collaborative document tips
clynnc
 
Audience & analysis paper tips
Audience & analysis paper tipsAudience & analysis paper tips
Audience & analysis paper tips
clynnc
 
Destiny tutorial
Destiny tutorialDestiny tutorial
Destiny tutorial
clynnc
 
Book research tutorial
Book research tutorialBook research tutorial
Book research tutorial
clynnc
 
Dictionary tutorial
Dictionary tutorialDictionary tutorial
Dictionary tutorial
clynnc
 
Sample rhetorical analysis
Sample rhetorical analysisSample rhetorical analysis
Sample rhetorical analysis
clynnc
 
Quiz show inductive & deductive reasoning
Quiz show inductive & deductive reasoningQuiz show inductive & deductive reasoning
Quiz show inductive & deductive reasoning
clynnc
 
Peer assessment instructions
Peer assessment instructionsPeer assessment instructions
Peer assessment instructions
clynnc
 
Start here
Start hereStart here
Start here
clynnc
 
Rhetorical analysis assignment brainstorming
Rhetorical analysis assignment brainstormingRhetorical analysis assignment brainstorming
Rhetorical analysis assignment brainstorming
clynnc
 
Mla format 2
Mla format 2Mla format 2
Mla format 2
clynnc
 
Creating Graphs in Excel
Creating Graphs in ExcelCreating Graphs in Excel
Creating Graphs in Excel
clynnc
 
Brainstorming questions
Brainstorming questionsBrainstorming questions
Brainstorming questions
clynnc
 
Ethos pathos logos
Ethos pathos logosEthos pathos logos
Ethos pathos logos
clynnc
 
Research strategies
Research strategiesResearch strategies
Research strategies
clynnc
 
Research strategies
Research strategiesResearch strategies
Research strategies
clynnc
 
Mla format 2
Mla format 2Mla format 2
Mla format 2
clynnc
 
MLA Format 1
MLA Format 1MLA Format 1
MLA Format 1
clynnc
 
Collaborative document tips
Collaborative document tipsCollaborative document tips
Collaborative document tips
clynnc
 
Audience & analysis paper tips
Audience & analysis paper tipsAudience & analysis paper tips
Audience & analysis paper tips
clynnc
 
Destiny tutorial
Destiny tutorialDestiny tutorial
Destiny tutorial
clynnc
 
Book research tutorial
Book research tutorialBook research tutorial
Book research tutorial
clynnc
 
Dictionary tutorial
Dictionary tutorialDictionary tutorial
Dictionary tutorial
clynnc
 

Recently uploaded (20)

CNS infections (encephalitis, meningitis & Brain abscess
CNS infections (encephalitis, meningitis & Brain abscessCNS infections (encephalitis, meningitis & Brain abscess
CNS infections (encephalitis, meningitis & Brain abscess
Mohamed Rizk Khodair
 
Drugs in Anaesthesia and Intensive Care,.pdf
Drugs in Anaesthesia and Intensive Care,.pdfDrugs in Anaesthesia and Intensive Care,.pdf
Drugs in Anaesthesia and Intensive Care,.pdf
crewot855
 
How To Maximize Sales Performance using Odoo 18 Diverse views in sales module
How To Maximize Sales Performance using Odoo 18 Diverse views in sales moduleHow To Maximize Sales Performance using Odoo 18 Diverse views in sales module
How To Maximize Sales Performance using Odoo 18 Diverse views in sales module
Celine George
 
Redesigning Education as a Cognitive Ecosystem: Practical Insights into Emerg...
Redesigning Education as a Cognitive Ecosystem: Practical Insights into Emerg...Redesigning Education as a Cognitive Ecosystem: Practical Insights into Emerg...
Redesigning Education as a Cognitive Ecosystem: Practical Insights into Emerg...
Leonel Morgado
 
Origin of Brahmi script: A breaking down of various theories
Origin of Brahmi script: A breaking down of various theoriesOrigin of Brahmi script: A breaking down of various theories
Origin of Brahmi script: A breaking down of various theories
PrachiSontakke5
 
antiquity of writing in ancient India- literary & archaeological evidence
antiquity of writing in ancient India- literary & archaeological evidenceantiquity of writing in ancient India- literary & archaeological evidence
antiquity of writing in ancient India- literary & archaeological evidence
PrachiSontakke5
 
spinal cord disorders (Myelopathies and radiculoapthies)
spinal cord disorders (Myelopathies and radiculoapthies)spinal cord disorders (Myelopathies and radiculoapthies)
spinal cord disorders (Myelopathies and radiculoapthies)
Mohamed Rizk Khodair
 
How to Share Accounts Between Companies in Odoo 18
How to Share Accounts Between Companies in Odoo 18How to Share Accounts Between Companies in Odoo 18
How to Share Accounts Between Companies in Odoo 18
Celine George
 
Cultivation Practice of Garlic in Nepal.pptx
Cultivation Practice of Garlic in Nepal.pptxCultivation Practice of Garlic in Nepal.pptx
Cultivation Practice of Garlic in Nepal.pptx
UmeshTimilsina1
 
puzzle Irregular Verbs- Simple Past Tense
puzzle Irregular Verbs- Simple Past Tensepuzzle Irregular Verbs- Simple Past Tense
puzzle Irregular Verbs- Simple Past Tense
OlgaLeonorTorresSnch
 
Pope Leo XIV, the first Pope from North America.pptx
Pope Leo XIV, the first Pope from North America.pptxPope Leo XIV, the first Pope from North America.pptx
Pope Leo XIV, the first Pope from North America.pptx
Martin M Flynn
 
Ancient Stone Sculptures of India: As a Source of Indian History
Ancient Stone Sculptures of India: As a Source of Indian HistoryAncient Stone Sculptures of India: As a Source of Indian History
Ancient Stone Sculptures of India: As a Source of Indian History
Virag Sontakke
 
LDMMIA Reiki News Ed3 Vol1 For Team and Guests
LDMMIA Reiki News Ed3 Vol1 For Team and GuestsLDMMIA Reiki News Ed3 Vol1 For Team and Guests
LDMMIA Reiki News Ed3 Vol1 For Team and Guests
LDM & Mia eStudios
 
The role of wall art in interior designing
The role of wall art in interior designingThe role of wall art in interior designing
The role of wall art in interior designing
meghaark2110
 
What is the Philosophy of Statistics? (and how I was drawn to it)
What is the Philosophy of Statistics? (and how I was drawn to it)What is the Philosophy of Statistics? (and how I was drawn to it)
What is the Philosophy of Statistics? (and how I was drawn to it)
jemille6
 
How to Create Kanban View in Odoo 18 - Odoo Slides
How to Create Kanban View in Odoo 18 - Odoo SlidesHow to Create Kanban View in Odoo 18 - Odoo Slides
How to Create Kanban View in Odoo 18 - Odoo Slides
Celine George
 
How to Manage Amounts in Local Currency in Odoo 18 Purchase
How to Manage Amounts in Local Currency in Odoo 18 PurchaseHow to Manage Amounts in Local Currency in Odoo 18 Purchase
How to Manage Amounts in Local Currency in Odoo 18 Purchase
Celine George
 
2025 The Senior Landscape and SET plan preparations.pptx
2025 The Senior Landscape and SET plan preparations.pptx2025 The Senior Landscape and SET plan preparations.pptx
2025 The Senior Landscape and SET plan preparations.pptx
mansk2
 
The History of Kashmir Karkota Dynasty NEP.pptx
The History of Kashmir Karkota Dynasty NEP.pptxThe History of Kashmir Karkota Dynasty NEP.pptx
The History of Kashmir Karkota Dynasty NEP.pptx
Arya Mahila P. G. College, Banaras Hindu University, Varanasi, India.
 
*"Sensing the World: Insect Sensory Systems"*
*"Sensing the World: Insect Sensory Systems"**"Sensing the World: Insect Sensory Systems"*
*"Sensing the World: Insect Sensory Systems"*
Arshad Shaikh
 
CNS infections (encephalitis, meningitis & Brain abscess
CNS infections (encephalitis, meningitis & Brain abscessCNS infections (encephalitis, meningitis & Brain abscess
CNS infections (encephalitis, meningitis & Brain abscess
Mohamed Rizk Khodair
 
Drugs in Anaesthesia and Intensive Care,.pdf
Drugs in Anaesthesia and Intensive Care,.pdfDrugs in Anaesthesia and Intensive Care,.pdf
Drugs in Anaesthesia and Intensive Care,.pdf
crewot855
 
How To Maximize Sales Performance using Odoo 18 Diverse views in sales module
How To Maximize Sales Performance using Odoo 18 Diverse views in sales moduleHow To Maximize Sales Performance using Odoo 18 Diverse views in sales module
How To Maximize Sales Performance using Odoo 18 Diverse views in sales module
Celine George
 
Redesigning Education as a Cognitive Ecosystem: Practical Insights into Emerg...
Redesigning Education as a Cognitive Ecosystem: Practical Insights into Emerg...Redesigning Education as a Cognitive Ecosystem: Practical Insights into Emerg...
Redesigning Education as a Cognitive Ecosystem: Practical Insights into Emerg...
Leonel Morgado
 
Origin of Brahmi script: A breaking down of various theories
Origin of Brahmi script: A breaking down of various theoriesOrigin of Brahmi script: A breaking down of various theories
Origin of Brahmi script: A breaking down of various theories
PrachiSontakke5
 
antiquity of writing in ancient India- literary & archaeological evidence
antiquity of writing in ancient India- literary & archaeological evidenceantiquity of writing in ancient India- literary & archaeological evidence
antiquity of writing in ancient India- literary & archaeological evidence
PrachiSontakke5
 
spinal cord disorders (Myelopathies and radiculoapthies)
spinal cord disorders (Myelopathies and radiculoapthies)spinal cord disorders (Myelopathies and radiculoapthies)
spinal cord disorders (Myelopathies and radiculoapthies)
Mohamed Rizk Khodair
 
How to Share Accounts Between Companies in Odoo 18
How to Share Accounts Between Companies in Odoo 18How to Share Accounts Between Companies in Odoo 18
How to Share Accounts Between Companies in Odoo 18
Celine George
 
Cultivation Practice of Garlic in Nepal.pptx
Cultivation Practice of Garlic in Nepal.pptxCultivation Practice of Garlic in Nepal.pptx
Cultivation Practice of Garlic in Nepal.pptx
UmeshTimilsina1
 
puzzle Irregular Verbs- Simple Past Tense
puzzle Irregular Verbs- Simple Past Tensepuzzle Irregular Verbs- Simple Past Tense
puzzle Irregular Verbs- Simple Past Tense
OlgaLeonorTorresSnch
 
Pope Leo XIV, the first Pope from North America.pptx
Pope Leo XIV, the first Pope from North America.pptxPope Leo XIV, the first Pope from North America.pptx
Pope Leo XIV, the first Pope from North America.pptx
Martin M Flynn
 
Ancient Stone Sculptures of India: As a Source of Indian History
Ancient Stone Sculptures of India: As a Source of Indian HistoryAncient Stone Sculptures of India: As a Source of Indian History
Ancient Stone Sculptures of India: As a Source of Indian History
Virag Sontakke
 
LDMMIA Reiki News Ed3 Vol1 For Team and Guests
LDMMIA Reiki News Ed3 Vol1 For Team and GuestsLDMMIA Reiki News Ed3 Vol1 For Team and Guests
LDMMIA Reiki News Ed3 Vol1 For Team and Guests
LDM & Mia eStudios
 
The role of wall art in interior designing
The role of wall art in interior designingThe role of wall art in interior designing
The role of wall art in interior designing
meghaark2110
 
What is the Philosophy of Statistics? (and how I was drawn to it)
What is the Philosophy of Statistics? (and how I was drawn to it)What is the Philosophy of Statistics? (and how I was drawn to it)
What is the Philosophy of Statistics? (and how I was drawn to it)
jemille6
 
How to Create Kanban View in Odoo 18 - Odoo Slides
How to Create Kanban View in Odoo 18 - Odoo SlidesHow to Create Kanban View in Odoo 18 - Odoo Slides
How to Create Kanban View in Odoo 18 - Odoo Slides
Celine George
 
How to Manage Amounts in Local Currency in Odoo 18 Purchase
How to Manage Amounts in Local Currency in Odoo 18 PurchaseHow to Manage Amounts in Local Currency in Odoo 18 Purchase
How to Manage Amounts in Local Currency in Odoo 18 Purchase
Celine George
 
2025 The Senior Landscape and SET plan preparations.pptx
2025 The Senior Landscape and SET plan preparations.pptx2025 The Senior Landscape and SET plan preparations.pptx
2025 The Senior Landscape and SET plan preparations.pptx
mansk2
 
*"Sensing the World: Insect Sensory Systems"*
*"Sensing the World: Insect Sensory Systems"**"Sensing the World: Insect Sensory Systems"*
*"Sensing the World: Insect Sensory Systems"*
Arshad Shaikh
 

Creating graphs in excel

  • 1. In this video, you will learn to • Gather data from surveymonkey.com • Create a graph in Microsoft Excel • Paste your graph into Microsoft Word Feel free to pause, rewind, or rewatch this video.
  • 2. I’ve created my survey and am still on the “Design Survey” tab.
  • 3. In order to allow people to take my survey, I click on the button “Collect Response.” Then, I choose “Web Link” and copy the link that pops up. This is the link I will share with my peers on the discussion board.
  • 4. Once I’ve collected responses from my audience (my peers), I can look at the results by clicking on the “Analyze Results” tab. Then, I get a really cool graph, but unfortunately, I can’t copy and paste it. So I’ll have to make my own.
  • 5. When I scroll down the page, I get the number of responses for each choice. Even though I am offered a percentile, I am going to use the actual number of responses instead.
  • 6. Now, I open a new document in Excel and enter my data. Do NOT include blank cells in your data because it will mess up your graph when you make it. Just cram everything together like I have. It doesn’t have to look pretty.
  • 7. Highlight your data. Do not highlight any empty cells. Then, click on the “Charts” tab. Finally, choose the kind of graph you want to make.
  • 8. I have chosen a column chart, more specifically the “Clustered Column” chart.
  • 9. Now I have a nice little graph! But it needs improvements. Warning: You have to click on your chart in order to modify it. If you click outside the chart, you will lose the option to modify it. Just click back on it again.
  • 10. First I want to get rid of the legend on the side since it is not conveying any useful information. So I just click on it and press either “Delete” or “Backspace” on my keyboard.
  • 11. I also want to modify my title since it has the word “Number” in it for some reason. I just click on the title and make changes.
  • 12. I also want to give more information about what my data means, so I want to add a title to the horizontal axis and the vertical axis. I click on the “Chart Layout” tab and then on the “Axis Titles” tab.
  • 13. Now I can give my graph a horizontal title… …and a vertical title.
  • 14. This is what my graph looks like now. But I’m not quite finished.
  • 15. I want to place the value above each line of the bar chart, so I’m going to go back to the “Chart Layout” tab, click on “Data Labels,” and choose “Value” (not shown).
  • 16. Now I have a gorgeous chart to put in my paper!
  • 17. Adding my chart to my paper is very easy. I just click on the chart and then copy it.
  • 18. Then, I open a new Word document and paste it in.
  • 19. Underneath, be sure to give your graph a title.
  • 20. To make your graph easier to move around, click on the graph itself. Then, choose the “Format” tab that pops up, “Wrap Text,” and “Top and Bottom” (not shown).
  • 21. That’s the end of this tutorial. I hope you found it helpful.
  翻译: