How To Set Up A Graph

Download Commodity

Download Article

If y'all're looking for a groovy manner to visualize data in Microsoft Excel, you can create a graph or chart. Whether you're using Windows or macOS, creating a graph from your Excel data is quick and piece of cake, and you tin can even customize the graph to look exactly how yous want. This wikiHow tutorial will walk you through making a graph in Excel.

Steps

one

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

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

Advert
3
Consider the type of graph y'all want to brand. At that place are three basic types of graph that you tin can create in Excel, each of which works best for certain types of information:^[1]
- Bar - Displays ane or more than sets of data using vertical bars. Best for list differences in data over time or comparing two similar sets of data.
- Line - Displays one or more sets of information using horizontal lines. Best for showing growth or decline in data over time.
- Pie - Displays one set of data as fractions of a whole. Best for showing a visual distribution of data.
four
Add your graph'south headers. The headers, which determine the labels for individual sections of information, should go in the height row of the spreadsheet, starting with cell B1 and moving correct from in that location.
- For case, to create a set of information called "Number of Lights" and another set called "Power Bill", you would type Number of Lights into cell B1 and Power Bill into C1
- Ever leave cell A1 bare.
5
Add together your graph's labels. The labels that separate rows of data become in the A cavalcade (starting in cell A2). Things like time (e.yard., "Day 1", "Twenty-four hours two", etc.) are usually used as labels.
- For example, if you're comparing your budget with your friend's upkeep in a bar graph, you might label each column by week or month.
- You should add together a characterization for each row of information.
6
Enter your graph's information. Starting in the prison cell immediately below your showtime header and immediately to the right of your first label (most likely B2), enter the numbers that you want to use for your graph.
- You lot can press the Tab ↹ central one time you're done typing in i cell to enter the data and jump i prison 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 tiptop-left corner of the data group (due east.g., prison cell A1) to the bottom-right corner, making certain to select the headers and labels every bit well.
8

Click the Insert tab. Information technology'southward virtually the summit of the Excel window. Doing so volition open a toolbar below the Insert tab.
nine
Select a graph type. In the "Charts" section of the Insert toolbar, click the visual representation of the type of graph that you want to use. A drib-down menu with dissimilar 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.
10
Select a graph format. In your selected graph'south drop-downwardly bill of fare, click a version of the graph (e.g., 3D) that you want to use in your Excel certificate. The graph will be created in your document.
- You lot tin also hover over a format to meet a preview of what information technology will look similar when using your data.
11
Add a title to the graph. Double-click the "Nautical chart Title" text at the top of the chart, and then delete the "Chart Championship" text, replace it with your own, and click a blank infinite on the graph.
- On a Mac, you lot'll instead click the Design tab, click Add together Chart Element, select Chart Title, click a location, and blazon in the graph's title.^[2]
12
Salvage your document. To practice so:
- Windows - Click File, click Save As, double-click This PC, click a save location on the left side of the window, type the certificate's name into the "File name" text box, and click Save.
- Mac - Click File, click Save As..., enter the document'southward 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 centrality to a vertical axis in Excel?

Click "Edit" and and then printing "Motility." If this doesn't work, double click the axis and use the dots to movement it.
Question

How do I print a graph only in Excel?

Type control p on your laptop or go to impress on the page font of your screen?
Question

How do I characterization a Series?

Jayna Akanova

Community Answer

Right-click the chart with the data series yous want to rename, and click Select Data. In the Select Information Source dialog box, under Fable Entries (Series), select the data series, and click Edit. In the Series name box, type the proper name you desire to utilise.
Question

How to rename information series?

Jayna Akanova

Customs Answer

Right-click the chart with the data series yous want 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 proper noun box, type the proper noun you desire to utilize.
Question

How can I alter the range of numbers in the vertical centrality?

Jayna Akanova

Community Answer

In a nautical chart, click the value axis that you want to change, or practise the following to select the axis from a list of nautical chart elements: Click anywhere in the nautical chart. On the Format tab, in the Current Selection group, click the pointer next to the Nautical chart Elements box, and so click Vertical (Value) Axis.
Question

How can I add some other vertical axis in a graph?

Deborah Archary

Customs Answer

Assuming you 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 heed, Column A is used for your horizontal axis information. B1, C1, D1 etc. can exist used as headings for each vertical centrality. Input information from cell 2 onwards in each cavalcade. Just make sure any information y'all input into these columns correlate cell past cell with your column A horizontal axis data. The information inputted in these columns i.e. B, C, D, East, etc. will be converted into a bar in your bar graph when yous select all your information, click "insert", then "chart" and choose bar graph.
Question

How practise I change a data series?

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

How do I alter the color on my bar graph?

Ahhna Shrivstava

Community Respond

Click on the chart and go to chart design. You will get some options such equally white to black. To alter the color of bars, just click on a bar. All bars will automaticly get selected. Go to format and change the colour.

Enquire a Question

200 characters left

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

Submit

You can change the graph's visual appearance on the Design tab.
If you don't want to select a specific blazon of graph, you tin click Recommended Charts and and then select a graph from Excel's recommendation window.

Advertizing

Some graph formats won't include all of your data, or will brandish information technology in a disruptive manner. Information technology's important to choose a graph format that works with your data.

Advertizing

Most This Article

Article Summary X

ane. Enter the graph's headers.
2. Add the graph'south labels.
3. Enter the graph'south data.
4. Select all data including headers and labels.
5. Click Insert.
6. Select a graph blazon.
7. Select a graph format.
viii. Add a championship to the graph.

Did this summary help you lot?

Cheers to all authors for creating a page that has been read 1,574,986 times.

Is this commodity up to appointment?