You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
This "Office Show" episode features a common dilemma: The budget data you want to analyze in Excel contains so many rows and columns of numbers that it seems like an impossible task to get it all sorted out. Meanwhile, there's a deadline looming and mounting pressure to figure out how to save money.
This is where PivotTables come in. PivotTables are brilliant at making sense out of walls of numbers, because they do a lot of the work for you. They can automatically organize and summarize your data, so you can immediately see things like what areas of your business are performing the best (and, unfortunately, the worst).
So what situations really call for a PivotTable? Consider creating one when you want to:
We have plenty of resources on creating PivotTables, starting with this blog post and video by PivotTable expert Frederique Klitgaard. A few other helpful links:
Create or delete a PivotTable or PivotChart report
Quick start: Create a PivotTable report
Overview of PivotTable and PivotChart reports
What if you need to connect your Excel workbook to multiple data sources at once? That's where PowerPivot, a free add-in for Excel, can really help. It also increases Excel's capacity to deal with hundreds of millions of rows. We'll have more on PowerPivot in an upcoming post.
-- Doug Kim and Frederique Klitgaard
In Excel 2010, the drop down list in a pivot table connected to ssas in now limited to 10,000 items. In Excel 2007 the limit was 32,000. Is there any way to change this in 2010.
Hi I have been working with excel and pivot tables for a long time. One thing really bugs me and that is why is excel completely incapable of doing a decent job with error bars. In most places you cannot put a graph up without error bars and I do alot of messing around and manual manipulation of data for something that appears to be a feature. A pivot table can correctly average data and even find the standard deviation but for some reason when you create a chart it chokes on making error bars with standard deviation. I really wish someone would finally fix this it has been like this for many versions of excel. Currently I am using 2007.
Here is an example of what a pivot table shouild do you make a pivot table and set the data to average, then make the pivot chart. Now you have a bunch of say bar graphs with average values. Each one of these should be able to have a standard deviation upper and lower error bar and it should do this based on all the numbers which the pivot chart used to make that average value for single bar.
Instead what excel does is comes up with some number a single number that it uses as the same exact error for all the bars in a chart.
I guess what bothers me so much is that the feature is sitting in the error bars dialog but it does not work and as far as I know has never worked. Why are completely non working features sitting there to confuse people.
Why did Microsoft Excel 2010 remove Pivot Table Fields' selected value displayed next to the Pivot Table Fields' variable like in Excel 2003? This is the most setback of Microsoft... can Microsoft advice how do I get that functionality back?
HI all, my apologies for the late responses. You can always go to the Excel forum here: answers.microsoft.com/.../excel for detailed Excel answers. Rudysloup, unfortunately you are absolutely right, the workaround for this is to create custom error bars, which we realize is not ideal.