Excel-erate


I got a question from someone about excel. Can you make some graphs pivot tables with microsoft office excel?

Well.. ofcourse you can, that’s excel all the way ;-)…

Here is how…

Suppose you have an excel sheet with your data in it

Now create a second tab. And select from the ‘data’ menu on top ‘PivotTable and Pivot Chart Report’
Select microsoft excel list or database (I assume you want to build an analysis on data which is already available in your workbook and not from an external source)
Also pick pivottable

The next window will allow you to select your datarange (which should be the data which is already present in your previous tab).
(Forgive me the foreign language of some of the screenshots but I haven’t got an english version of excel :P)
Now, navigate to the page where your data is and select all the data you want to use as following:

Click next. Select the page where you want to add the pivot table. I picked current page cell A1. Then click Finish

The result should be something like this

Now all you have to do is drop the fields in the sections where you want to see them.
(I dropped type in columns, month in rows and qty in the datarange)

Et voila :-)

 

Advertisements

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: