PivotTables can save the day in a budget crisis

re: PivotTables can save the day in a budget crisis

Doug Kim — Thu, 05 May 2011 19:54:02 GMT

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.

re: PivotTables can save the day in a budget crisis

moonlight — Sat, 16 Apr 2011 18:30:27 GMT

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?

re: PivotTables can save the day in a budget crisis

rudysloup — Thu, 07 Apr 2011 04:57:41 GMT

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.

re: PivotTables can save the day in a budget crisis

Mertzlufft — Mon, 28 Mar 2011 21:52:07 GMT

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.