How to Draw Campbell Diagram in Excel

Download Article

Download Article

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

Steps

1. 1

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

2. ii

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

   Advertisement

3. 3

   Consider the type of graph you desire to make. At that place are three bones types of graph that y'all can create in Excel, each of which works best for certain types of data:^[1]

   • Bar - Displays one or more sets of data using vertical bars. Best for listing differences in data over time or comparing two similar sets of information.
   • Line - Displays ane or more sets of information using horizontal lines. Best for showing growth or decline in data over fourth dimension.
   • Pie - Displays one gear up of information as fractions of a whole. Best for showing a visual distribution of data.

4. iv

   Add together your graph's headers. The headers, which determine the labels for individual sections of data, should go in the meridian row of the spreadsheet, starting with jail cell B1 and moving correct from there.

   • For example, to create a set of data called "Number of Lights" and another ready called "Power Bill", you would blazon Number of Lights into cell B1 and Ability Bill into C1
   • Ever leave jail cell A1 blank.

5. 5

   Add your graph's labels. The labels that separate rows of data go in the A column (starting in prison cell A2). Things like time (e.g., "Twenty-four hour period 1", "Day 2", etc.) are usually used as labels.

   • For example, if you're comparing your budget with your friend's budget in a bar graph, you might label each column by week or calendar month.
   • You should add a label for each row of data.

6. six

   Enter your graph's data. Starting in the jail cell immediately beneath your kickoff header and immediately to the correct of your showtime label (near likely B2), enter the numbers that y'all want to utilise for your graph.

   • You can press the Tab ↹ cardinal in one case yous're done typing in one cell to enter the information and spring ane cell to the right if you're filling in multiple cells in a row.

7. 7

   Select your data. Click and drag your mouse from the top-left corner of the data group (due east.m., jail cell A1) to the lesser-right corner, making sure to select the headers and labels besides.

8. 8

   Click the Insert tab. It's virtually the superlative of the Excel window. Doing and so will open a toolbar below the Insert tab.

9. 9

   Select a graph type. In the "Charts" department of the Insert toolbar, click the visual representation of the type of graph that you want to use. A drop-downward 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 circumvolve.

10. x

    Select a graph format. In your selected graph's drop-down menu, click a version of the graph (e.g., 3D) that you desire to employ in your Excel document. The graph volition be created in your document.

    • You can besides hover over a format to see a preview of what it will look like when using your information.

11. 11

    Add a title to the graph. Double-click the "Nautical chart Title" text at the height of the chart, and so delete the "Chart Title" text, replace 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 Chemical element, select Chart Championship, click a location, and type in the graph'southward title.^[2]

12. 12

    Relieve your document. To practise and so:

    • Windows - Click File, click Save As, double-click This PC, click a save location on the left side of the window, type the document'south name into the "File name" text box, and click Salvage.
    • Mac - Click File, click Salve As..., enter the document'south name in the "Save As" field, select a save location by clicking the "Where" box and clicking a folder, and click Save.

    Advertizing

Add New Question

• Question

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

  

  Click "Edit" and and 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 just in Excel?

  

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

• Question

  How do I label a Series?

  

  Jayna Akanova

  Community Answer

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

• Question

  How to rename data serial?

  

  Jayna Akanova

  Community Answer

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

• Question

  How can I change the range of numbers in the vertical axis?

  

  Jayna Akanova

  Customs Answer

  In a nautical chart, click the value axis that y'all desire to modify, or do the following to select the centrality from a list of nautical chart elements: Click anywhere in the chart. On the Format tab, in the Current Selection group, click the arrow side by side to the Chart Elements box, and and then click Vertical (Value) Axis.

• Question

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

  

  Deborah Archary

  Community Answer

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

• Question

  How practise I modify a data series?

  

  To alter a data series, y'all would select a range of your spreadsheet appropriate for the data.

• Question

  How do I change the color on my bar graph?

  

  Ahhna Shrivstava

  Community Answer

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

Ask a Question

200 characters left

Include your e-mail address to get a message when this question is answered.

Submit

Advertisement

• You tin alter the graph's visual advent on the Design tab.

• If you don't desire to select a specific type of graph, yous can click Recommended Charts and so select a graph from Excel'south recommendation window.

Ad

• Some graph formats won't include all of your data, or will display it in a confusing manner. It'due south important to cull a graph format that works with your data.

Advertisement

Virtually This Article

Commodity Summary 10

1. Enter the graph'south headers.
ii. Add the graph's labels.
3. Enter the graph's information.
four. Select all data including headers and labels.
5. Click Insert.
6. Select a graph blazon.
7. Select a graph format.
viii. Add a title to the graph.

Did this summary help you?

Cheers to all authors for creating a folio that has been read 1,563,422 times.

Is this article up to date?

lopezconswited.blogspot.com

Source: https://www.wikihow.com/Create-a-Graph-in-Excel

Share this post