My pivot chart displays the data from the grand total of the pivot table, though I have set the data to pull from the column immediately to the left (whether or not I display or don't display totals). Further, when I move the cursor over the line on the graph, the line point retrieves the correct data, rather than the displayed grand total data. Is this a known bug? Is there a fix?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
2010 Pivot Chart Reference Error
- Thread starter CorinneD
- Start date
-
- Tags
- 2010 bug pivot chart
Excel Facts
Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Similar threads
- Question
- Replies
- 0
- Views
- 113
- Question
- Replies
- 10
- Views
- 3K
- Replies
- 0
- Views
- 1K
- Question
- Replies
- 4
- Views
- 922
- Solved
- Replies
- 4
- Views
- 451
