Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,168,840 members, 7,872,819 topics. Date: Wednesday, 26 June 2024 at 10:52 PM

How To Make A Graph In MS Excel - Computers - Nairaland

Nairaland Forum / Science/Technology / Computers / How To Make A Graph In MS Excel (710 Views)

I Need Computer Proficiency In Ms Word, Excel, Pp. / Who Will Teach Me Ms Excel And Powerpoint Here Pls / Do You Know You Can Become An Expert In Ms Acess & Excel In 2 Days (2) (3) (4)

(1) (Reply)

How To Make A Graph In MS Excel by bloglover(m): 12:39pm On Sep 07, 2012
1 Input the graph data. For the purposes of this example, type "Month" in cell A1, and type the months January through December in cells A2 through A13. In cell B1, type "Applications." For each month, increase the "Applications" number by 200. In cell B2, type "200," in cell B3 type "400" and so on. The last figure in the "Applications" column -- "2,400" -- is in cell B13.

2 Place the cursor on a cell within the data table. If the cursor is not on an item in the table, the chart will not know where to access the data. Go to the "Insert" tab. Click on the down arrow under the "Column" option in the "Charts" panel.

3 Select the first chart option under the "3-D Column" heading. A graph titled "Applications" will appear in your work area, showing 12 columns that represent the 12 numbers you entered in Step 1.

4 Click on the border of the chart to drag it to the desired location. Change the size of the graph by grabbing one of its corners and dragging it.

Tips & Warnings

To change the chart type of chart, right-click on the graph and select "Change Series Chart Type." Work with different types of charts and graphs to discover which works best in displaying the data. For instance, line charts might be more effective than pie charts to show drastic changes in data. You also can change the chart type by clicking on the graph to select it, then going to the "Design" tab and clicking on "Change Chart Type" on the "Type" panel.

Include the data table with the chart by clicking on the graph to select it, then going to the "Design" tab and choosing the "Layout 5" option on the "Chart Layouts" panel.

2 Likes

(1) (Reply)

Saka Joined The Wrong Team Mtn Loses Big In Mobile Number Portability Scheme / Brand New Laptop With 1year Warranty / Mysql

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 10
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.