LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default Excel 2007 charting errors with pivot tables

With Excel 2007 if I have a pivot chart set up using an olap data source with
4 Values (measures) which are the row values and each being graphed as a
separate line in a line graph - lets just say they are A, B, C, D.

If those items are listed in the Values box on the bottom right of the pivot
table fields list window as C, A, B, D when I hover over the legend for any
of those in the actual graph it will display the wrong one on the hover over.
If I hover over the first item in the legend "A" it will show me the hover
over details for the first item in the values box "C".

Not only that , but even worse it was displaying incorrect values in the
graph. If I resorted the values inside the "Values" box in the bottom right
of the Pivottable field list window it seemed to correct them, but it all
seems to be acting up.

I have a screen shot I could take of this if it will capture the hover over
and I could try to recreate the wrong values.

Has anyone seen this before? I have extensive experience with pivot
tables/olap and have never seen anything like this in prior versions.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 C# Charting problem [email protected] Charts and Charting in Excel 1 September 26th 06 02:46 AM
2007 Beta 2 Pivot Tables BrettStuart Excel Discussion (Misc queries) 1 August 21st 06 12:04 AM
Tips for Excel on Pivot Tables LMB New Users to Excel 4 July 30th 06 12:00 AM
Excel 2007 Charting causes blank screen Wil Charts and Charting in Excel 5 May 31st 06 01:34 AM
Macro for Pivot Tables Thomas Excel Discussion (Misc queries) 1 March 15th 05 01:03 AM


All times are GMT +1. The time now is 06:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"