1
vote
1answer
18 views

Excel Error Bars From Pivot Table

When Excel generates Standard Error error bars, it takes into account the number of data points. If a chart was generated from a pivot table, does Excel use the number of points in the pivot table, 1, ...
1
vote
1answer
527 views

How do I create a PivotChart from a subset of PivotTable data?

As part of a dashboard, I've created a PivotChart from a PivotTable in Excel 2010, but the PivotTable includes extra columns that are cluttering up the chart. But when I adjust the values list on the ...
1
vote
1answer
262 views

Chart Categories: How To Combine X-Axis Categories

The Task I'm putting together a dashboard wherein I'm building several charts. I've attempted to use a pivot chart (2D line chart) to pull data from two different pivots (with the same source data). ...
0
votes
0answers
184 views

Hiding a column from a pivot table without removing it from the chart

I have a pivot table with two columns: number of users who visited a website (impressions) and number of users who registered on the site (regs). The rows are for dates. I want to visualize the ...
1
vote
1answer
548 views

pivotslicer connected to multiple pivotcharts

Can I connect my pivotslicer to multiple pivotcharts, but on different category levels, so If for example I have a categorytree that goes: Department --> Section If I choose "Section A" Then I can ...
0
votes
1answer
2k views

Adding 80% horizontal goal line to pivot chart

I have a curve pivot chart to which I'd like to add a goal line with a static 80% horizontal line. I've seen some people suggest that one could merely add a column with 60% to the dataset. My dataset ...
0
votes
1answer
39 views

Blank Excel PivotChart

My Pivot Table has everything I want however,I want my chart to show how many Issues have the status of severe, mild, or moderate. But instead it is blank. What should I do?
2
votes
2answers
7k views

How to rotate text in axis category labels of Pivot Chart in Excel 2007?

I'm using a pivot chart in Excel to display data. My problem is: I can not influence the orientation of the text in the "axis" (don't know how to call it correctly, I'm sorry). As an example: In the ...
0
votes
1answer
347 views

Pull Data from Pivot Table to Grid on Different Worksheet

I am trying to make an Excel Workbook that contains the statistics of an XBox Tournament that our office is doing. Winner of the whole Tournament wins the XBox! It's fairly simple rules. Everyone will ...
1
vote
2answers
318 views

Desktop software for data analysis, like Business Objects “Lite”

My data set is sourced from ~100k users, with a few million records scattered over a dozen tables. Just too big for Excel, but not quite a data warehouse. It's sourced from a web-sites user base and ...
1
vote
2answers
1k views

Excel 2007 Pivot Tables: Overlapping issue hampers my summary sheet

I've created a Workbook that has 5 Pivot Tables (PT). I want to make a summary sheet that holds all these PT's, but when they expand the 'not allowed to overlap issue' causes me updating problems - ...
0
votes
4answers
5k views

My pivot chart has the wrong Y axis values but correct data point values

I created a pivot chart based on some raw data for the x axis (dates) and 4 calculated fields for the Y values. The values on resulting lines are correct (see the data label at the end of the line) ...
4
votes
4answers
1k views

MSFT Excel pivot table links to external data

Question1: What is the best online forum to ask MSFT Excel questions of the following variety? Question2: How can I link an excel pivot-table to a potentially changing source table without having to ...