how to draw graph in excel

Download Article

This wikiHow teaches you how to create a graph or chart in Microsoft Excel. You tin can create a graph from data in both the Windows and the Mac versions of Microsoft Excel.

Steps

i

Open Microsoft Excel. Its app icon resembles a green box with a white "Ten" on it.
2

Click Blank workbook . It's a white box in the upper-left side of the window.

Advertisement
iii
Consider the type of graph you lot want to make. There are iii basic types of graph that you can create in Excel, each of which works best for sure types of data:^[1]
- Bar - Displays i or more sets of data using vertical bars. Best for listing differences in information over time or comparing 2 similar sets of data.
- Line - Displays ane or more sets of data using horizontal lines. Best for showing growth or reject in data over time.
- Pie - Displays one set of data as fractions of a whole. Best for showing a visual distribution of data.
4
Add your graph's headers. The headers, which determine the labels for private sections of data, should become in the pinnacle row of the spreadsheet, starting with jail cell B1 and moving right from at that place.
- For example, to create a prepare of data chosen "Number of Lights" and another set called "Power Bill", you would type Number of Lights into prison cell B1 and Power Nib into C1
- E'er leave cell A1 blank.
5
Add together your graph's labels. The labels that separate rows of data go in the A column (starting in cell A2). Things like time (east.1000., "24-hour interval 1", "Day ii", etc.) are commonly used as labels.
- For example, if you're comparison your upkeep with your friend'due south budget in a bar graph, yous might label each column by week or month.
- You should add a label for each row of information.
six
Enter your graph's data. Starting in the cell immediately below your showtime header and immediately to the right of your start label (well-nigh likely B2), enter the numbers that yous want to use for your graph.
- You can printing the Tab ↹ key in one case y'all're done typing in i jail cell to enter the data and jump one cell to the right if you're filling in multiple cells in a row.
seven

Select your data. Click and drag your mouse from the acme-left corner of the data group (e.yard., prison cell A1) to the lesser-right corner, making sure to select the headers and labels also.
viii

Click the Insert tab. It'due south near the tiptop of the Excel window. Doing and so will open a toolbar beneath the Insert tab.
9
Select a graph type. In the "Charts" department of the Insert toolbar, click the visual representation of the type of graph that you lot desire to utilise. A drop-down menu with dissimilar options will appear.
- A bar graph resembles a series of vertical bars.
- A line graph resembles two or more squiggly lines.
- A pie graph resembles a sectioned-off circle.
10
Select a graph format. In your selected graph'southward driblet-down menu, click a version of the graph (due east.g., 3D) that you want to apply in your Excel document. The graph will exist created in your document.
- Y'all can also hover over a format to run across a preview of what it will look like when using your data.
11
Add a championship to the graph. Double-click the "Nautical chart Title" text at the acme of the chart, then delete the "Nautical chart Championship" text, supervene upon it with your own, and click a blank space on the graph.
- On a Mac, you'll instead click the Design tab, click Add Chart Element, select Chart Championship, click a location, and type in the graph's title.^[ii]
12
Salve your certificate. To do so:
- Windows - Click File, click Save Equally, double-click This PC, click a save location on the left side of the window, type the document's name into the "File name" text box, and click Salve.
- Mac - Click File, click Save Equally..., enter the document's proper noun in the "Relieve As" field, select a save location past clicking the "Where" box and clicking a folder, and click Relieve.
Advertisement

Add New Question

Question

How exercise I change the horizontal axis to a vertical centrality in Excel?

Click "Edit" then printing "Movement." If this doesn't work, double click the centrality and utilise the dots to move it.
Question

How do 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 Serial?

Jayna Akanova

Customs Answer

Right-click the chart with the data series you desire to rename, and click Select Data. In the Select Data Source dialog box, under Legend Entries (Series), select the data series, and click Edit. In the Serial name box, blazon the name you want to utilize.
Question

How to rename information series?

Jayna Akanova

Community Answer

Right-click the chart with the information series you want to rename, and click Select Data. In the Select Data Source dialog box, nether Legend Entries (Serial), select the information serial, and click Edit. In the Series name box, blazon the name you desire to use.
Question

How tin I alter the range of numbers in the vertical axis?

Jayna Akanova

Community Answer

In a nautical chart, click the value axis that you want to change, or do the post-obit to select the axis from a listing of nautical chart elements: Click anywhere in the nautical chart. On the Format tab, in the Current Option group, click the arrow next to the Chart Elements box, and so click Vertical (Value) Centrality.
Question

How tin I add another vertical axis in a graph?

Deborah Archary

Community Respond

Assuming yous already know how to make a basic bar graph from a workbook? If not, check out Wikihow's article "Create a Graph in Excel." Keep in mind, Cavalcade A is used for your horizontal centrality information. B1, C1, D1 etc. can be used as headings for each vertical axis. Input data from prison cell ii onwards in each column. Just make sure whatever information y'all input into these columns correlate cell by cell with your column A horizontal axis data. The information inputted in these columns i.e. B, C, D, E, etc. volition be converted into a bar in your bar graph when you lot select all your data, click "insert", then "chart" and cull bar graph.
Question

How do I modify a data serial?

To change a data serial, you would select a range of your spreadsheet advisable for the data.
Question

How do I change the color on my bar graph?

Ahhna Shrivstava

Customs Answer

Click on the chart and go to nautical chart design. You volition go some options such every bit white to black. To change the color of confined, but click on a bar. All bars will automaticly get selected. Become to format and change the color.

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Advertizement

You can modify the graph's visual advent on the Blueprint tab.
If y'all don't want to select a specific type of graph, you can click Recommended Charts and so select a graph from Excel's recommendation window.

Some graph formats won't include all of your data, or will display it in a confusing fashion. Information technology'southward important to choose a graph format that works with your information.

About This Commodity

Commodity Summary X

i. Enter the graph's headers.
two. Add together the graph'due south labels.
three. Enter the graph's data.
four. Select all data including headers and labels.
5. Click Insert.
vi. Select a graph blazon.
7. Select a graph format.
8. Add together a title to the graph.

Did this summary assistance you?

Thanks to all authors for creating a page that has been read 1,555,782 times.