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.

Also Read: MS Office Fun: Excel Games

How-To: Copy Excel cells into a Word document

Cheers

Vaibhav 

Advertisements

6 Responses

  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 […]

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

%d bloggers like this: