How Do I Draw A Graph Using Excel
Download Commodity
Download Article
If yous're looking for a keen way to visualize data in Microsoft Excel, you tin can create a graph or chart. Whether y'all're using Windows or macOS, creating a graph from your Excel data is quick and easy, and y'all can even customize the graph to look exactly how you desire. This wikiHow tutorial volition walk yous through making a graph in Excel.
Steps
-
1
Open Microsoft Excel. Its app icon resembles a green box with a white "X" on it.
-
2
Click Bare workbook . It's a white box in the upper-left side of the window.
Advertisement
-
3
Consider the blazon of graph you want to make. There are three basic types of graph that you tin create in Excel, each of which works best for sure types of information:[1]
- Bar - Displays i or more sets of information using vertical bars. Best for listing differences in data over time or comparing ii similar sets of data.
- Line - Displays one or more sets of data using horizontal lines. Best for showing growth or turn down in data over time.
- Pie - Displays one set up of data as fractions of a whole. Best for showing a visual distribution of information.
-
4
Add your graph's headers. The headers, which make up one's mind the labels for individual sections of data, should go in the top row of the spreadsheet, starting with cell B1 and moving right from there.
- For example, to create a set up of data chosen "Number of Lights" and some other fix called "Ability Bill", yous would type Number of Lights into jail cell B1 and Power Bill into C1
- Ever leave jail cell A1 blank.
-
5
Add your graph'due south labels. The labels that carve up rows of data become in the A column (starting in cell A2). Things similar time (east.g., "Day 1", "Mean solar day 2", etc.) are usually used as labels.
- For example, if you're comparing your upkeep with your friend'south budget in a bar graph, yous might characterization each column by week or month.
- You should add a label for each row of data.
-
half dozen
Enter your graph'due south information. Starting in the cell immediately below your first header and immediately to the right of your first label (most probable B2), enter the numbers that you want to utilise for your graph.
- You can press the Tab ↹ key once y'all're done typing in one cell to enter the data and spring i cell to the right if you're filling in multiple cells in a row.
-
7
Select your information. Click and drag your mouse from the pinnacle-left corner of the information group (e.g., cell A1) to the bottom-correct corner, making sure to select the headers and labels as well.
-
8
Click the Insert tab. It'south near the superlative of the Excel window. Doing so will open up a toolbar below the Insert tab.
-
ix
Select a graph type. In the "Charts" section of the Insert toolbar, click the visual representation of the blazon of graph that you desire to employ. A drop-down card with different options volition appear.
- A bar graph resembles a series of vertical confined.
- A line graph resembles two or more squiggly lines.
- A pie graph resembles a sectioned-off circle.
-
x
Select a graph format. In your selected graph's drop-downward carte du jour, click a version of the graph (e.chiliad., 3D) that you want to use in your Excel document. The graph will exist created in your certificate.
- You can too hover over a format to see a preview of what it will look like when using your data.
-
11
Add a title to the graph. Double-click the "Nautical chart Title" text at the acme of the chart, then delete the "Chart Title" text, supervene upon it with your own, and click a blank infinite on the graph.
- On a Mac, you'll instead click the Design tab, click Add Chart Element, select Chart Title, click a location, and type in the graph's title.[ii]
-
12
Save your certificate. To do so:
- Windows - Click File, click Save As, double-click This PC, click a salvage location on the left side of the window, blazon the document's name into the "File name" text box, and click Salve.
- Mac - Click File, click Relieve Every bit..., enter the document's proper name in the "Save As" field, select a save location by clicking the "Where" box and clicking a folder, and click Salvage.
Advertisement
Add New Question
-
Question
How do I change the horizontal axis to a vertical centrality in Excel?
Click "Edit" and then press "Move." If this doesn't work, double click the axis and utilize the dots to move it.
-
Question
How practice I print a graph only in Excel?
Type control p on your laptop or become to print on the page font of your screen?
-
Question
How do I label a Series?
Jayna Akanova
Community Reply
Right-click the chart with the data series you want to rename, and click Select Data. In the Select Data Source dialog box, under Legend Entries (Serial), select the data series, and click Edit. In the Series name box, type the proper noun yous want to use.
-
Question
How to rename information serial?
Jayna Akanova
Customs Answer
Right-click the nautical chart with the data series you desire to rename, and click Select Data. In the Select Information Source dialog box, under Legend Entries (Series), select the data series, and click Edit. In the Serial name box, type the name you want to use.
-
Question
How can I change the range of numbers in the vertical centrality?
Jayna Akanova
Community Answer
In a chart, click the value centrality that you want to change, or practise the following to select the axis from a list of chart elements: Click anywhere in the chart. On the Format tab, in the Electric current Selection group, click the arrow adjacent to the Chart Elements box, and and then click Vertical (Value) Axis.
-
Question
How tin I add another vertical axis in a graph?
Deborah Archary
Community Answer
Assuming yous already know how to make a basic bar graph from a workbook? If not, cheque out Wikihow's commodity "Create a Graph in Excel." Keep in mind, Cavalcade A is used for your horizontal axis information. B1, C1, D1 etc. tin exist used as headings for each vertical axis. Input data from prison cell 2 onwards in each column. Just make sure whatsoever information you lot input into these columns correlate cell by cell with your column A horizontal centrality information. The information inputted in these columns i.eastward. B, C, D, Eastward, etc. will be converted into a bar in your bar graph when you select all your information, click "insert", and then "chart" and choose bar graph.
-
Question
How practice I change a data serial?
To change a data series, you would select a range of your spreadsheet advisable for the data.
-
Question
How practise I alter the color on my bar graph?
Ahhna Shrivstava
Community Answer
Click on the nautical chart and go to chart pattern. Y'all will get some options such as white to black. To modify the color of bars, simply click on a bar. All bars will automaticly get selected. Get to format and change the color.
Ask a Question
200 characters left
Include your email accost to get a message when this question is answered.
Submit
Advert
-
You tin alter the graph's visual appearance on the Design tab.
-
If you don't desire to select a specific blazon of graph, y'all tin can click Recommended Charts so select a graph from Excel'southward recommendation window.
Advertizing
-
Some graph formats won't include all of your data, or will display information technology in a confusing manner. It's important to cull a graph format that works with your data.
Advertizing
About This Article
Article Summary X
ane. Enter the graph'southward headers.
2. Add together the graph'due south labels.
three. Enter the graph'southward information.
4. Select all data including headers and labels.
five. Click Insert.
half dozen. Select a graph type.
7. Select a graph format.
8. Add a title to the graph.
Did this summary help y'all?
Thanks to all authors for creating a folio that has been read one,569,378 times.
Is this article up to appointment?
Source: https://www.wikihow.com/Create-a-Graph-in-Excel
Posted by: milsapmustrien.blogspot.com
0 Response to "How Do I Draw A Graph Using Excel"
Post a Comment