Pages

Tuesday, November 22, 2011

Create a Simple Chart in Excel


Today we are going to create a simple Column chart in excel showing sales per year.

Follow these simple steps to create a simple chart in excel. I am using excel 2007 for this example.
Step 1:- Create a simple table in excel as shown in the figure below.


Step 2:- First of all click on an empty cell, then go to Insert > Charts > Column and then click on Stacked Column.


Step 3:- An empty Chart Area will be created. Right click on the Chart Area and then click on Select Data.


Step 4:- Select Data Source dialog box will open. Now click on the Add button as in the image below.


Another pop up dialog box will appear. In the Series name text box select the title sales and in the Series values box click on the first data under sales and then click and drag it up to the last entry of the table.
OR
Click on the first number under Sales hold Shift and then click on the last data.

And then click OK. 


Step 5:- Now the earlier pop up window will reappear but a Series named Sales will appear on the Left hand side. Now click on the Edit button on the right hand side of the window.

One more window will appear. This time select all the years under the title Years and click OK.


Step 6:- Now again click OK on the pop-up window and the final chart will look like this.


1 comment:

  1. Awesum Work Dude !!!!!
    Now i m expecting atleast 100 such more post by the time our project completes ....
    Gr8 job !!!!!!!!

    ReplyDelete

HostGator Promos