«
»

How-To: Create Basic Charts using Microsoft Excel

During my conversations with people, i have understood that not many people know how to create a basic chart using Microsoft Excel. For all those and for the regular readers of my blog, i am putting up this post which shall describe a step by step procedure for creating basic charts and graphs in Microsoft Excel.

The below presented excel snapshot clearly shows the number of employees on rolls with a company on a particular date in both tabular as well as line graph way. The graph is nothing but a linear representation of the table.

Chart in Excel

In order to achieve this graph, follow the below mentioned steps:

  1. Enter the data in the table as mentioned above in respective cells.
  2. Select cells from B2 to C5.
  3. Select Insert -> Chart.
  4. Select Chart Type as Line. Then select one of the line charts. ( We chose Line with Markers displayed at each data value).
  5. Select Next
  6. Under Chart Title enter Employee Strength.
  7. Enter ” Year” as value for Category (X) Axis.
  8. Enter ” Number of Employees” as value for Value (Y) Axis.
  9. Press Finish.

Hope this tutorial helps you with creating some basic charts.

Also Read: MS Office Fun: Excel Games

How-To: Copy Excel cells into a Word document

You can follow me on Twitter at http://twitter.com/vaibhav1981

Do stay tuned to Technofriends for more, one of the best ways of doing so is by subscribing to our feeds. You can subscribe to Technofriends feed by clicking here.

Related posts:

  1. [How-To] Hide “0″ in Microsoft Excel Chart Axis
  2. [Charts] Create Simple and Interactive Charts with Chartle.net
  3. [How-To] Calculate Equated Monthly Installment using MS Excel
  4. [How-To] Shrink Excel Text
  5. [How-To] Conditional Formatting Using Microsoft Excel

This entry was posted on Friday, February 1st, 2008 at 1:41 pm and is filed under How-To. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

8 Responses to “How-To: Create Basic Charts using Microsoft Excel”

  1. [...] MacSparky wrote an interesting post today onHere’s a quick excerptDuring my conversations with people, i have understood that not many people know how to create a basic chart using Microsoft Excel. For all those and for the regular readers of my blog, i am putting up this post which shall describe a … [...]

  2. [...] MacSparky wrote an interesting post today onHere’s a quick excerptDuring my conversations with people, i have understood that not many people know how to create a basic chart using Microsoft Excel. For all those and for the regular readers of my blog, i am putting up this post which shall describe a … [...]

  3. [...] Original post by Vaibhav Pandey–>Technofriends Team [...]

  4. i always aspect that kinds of updates from you..;-)

    thanks dear.

  5. [...] How-To: Create Basic Charts using Microsoft Excel [...]

  6. [...] to the way humans are often tuned to behave. As known, we can do a lots with Microsoft Office like Creating Basic Chart using MS Excel, Calculating our Equated Monthly Installments, playing games on MS Excel being some of them we have [...]

  7. [...] How-To: Create Basic Charts using Microsoft Excel [...]

  8. [...] How-To: Create Basic Charts using Microsoft Excel [...]

Leave a Reply