IT ANSWERS – Making a graph on Microsoft Excel

Making a graph on Microsoft Excel

So, whilst at work your boss asks you to create a pie chart or line graph on some figures they just mailed you. Looking at the figures it occurs to you it has been a while since you made a graph let alone on Excel. So here you go, even the easy things sometimes need repeating:

Microsoft Excel is one of the most offen used programs in the working world, it was created to help in expressing figures, creating tables, calculating complex sums and one of its most important features is its power to display figures in diagrammatic forms.  It makes it so easy to create a graph.

All you need to do is supply the data for the graph and then let Excel create the graph for you in second through the click of a few buttons. Excel provides several graph options from which to choose. So not only is it easy but it’s also very customizable.

Here we go, in 8 simple steps (but a pre step is, make sure you have MS Office 07. This makes life so much easier in so many ways):

  1. Label the data you want to graph. In Row 1, type the labels for each piece of data you plan to graph. For example, type “Month” in cell A1 and “Units” in cell B1.
  2. Enter the data that you want to graph. Under the labels you have set up at the top of each column, type the information you want to graph. For example, type the months of the year under the heading in Column A (“Jan” in A2) and the units under the heading in Column B, to correspond with the months in Column A.
  3. Highlight the data for the graph. Click and drag your mouse across the data in the Excel spreadsheet.
  4. Click on the “Insert” tab, the second tab at the top of the screen.
  5. Locate the “Charts” section of the insert ribbon. Several types of graphs (called “charts” in Excel) are available.
  6. Click on the type of graph you want to create. Options for that type of graph will display.
  7. Click on the option for the graph you want Excel to make. Excel will then make a graph displaying the data you provided in the Excel spreadsheet.
  8. Change text on the graph, if needed. If you want to change the title or other text on the graph, click on the text you want to change and then type in your changes.

 And there you have it, you’ll be looking like a pro in no time, but always make sure you provide enough data for the type of graph you select in Excel. Some graphs require more than two columns of data. Also be sure to select the type of graph in Excel that best represents the data. You can experiment with several types of graphs to find the one that best meets your needs.

Try it out and experiment with different settings, you’ll be surprised with what you can do.

For more tips and tricks check out our site HERE or look us up on Facebook and be sure to follow us on Twitter @iTanswersng.

Advertisements

About th3rdculture

This is a place to go for entertainment, information and inspiration. It’s a place of escape, where you can find completely original content in the forms of written work by our esteemed Writers and great visuals courtesy of our Arts team. Creativity is gift which we want to share with the world, we're here to take you to places you can only imagine.
This entry was posted in Home, Words and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s