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: 1
Default Random Missing Axis Labels - Pivot Charts

I am a reasonably experienced excel user, who has been using pivot
tables/charts in Office 2003 since, well, 2003. I analyze hundreds of
thousands of lines of data, and find the pivot table feature very powerful.

I recently switched to Office 2007. It's strange, but I'm getting used to it.

Several engineers in my office, including me, are having a show-stopping
problem with pivot charts. When we have multiple data fields in the X-axis,
the field lables disappear randomly.

Below are links to jpegs showing examples of the problem.

In the image labeled 'minimal data', all the X-axis lables are visible.

In the image 'less data', I have added (unfiltered) additional data points,
adding more information to the primary X-axis field. As you can see from the
picture, some of the 2nd level X-axis lables have dissapeared.

In the image 'all data', I have added all the available data points. As a
result, even more of the 2nd level X-axis lables have dissapeard, and even
one of the 3rd level axis lables is gone.

I have tried every option I can to get them back, including, but not limited
to: change font sizes, changing printer driver, changing interval settings,
tic marks, alignment settings, even page size. The defect even remains when
I print.

I believe this is a bug. Anyone seen it before, and have a fix?

I'm running XP Prof V2002 with SP2, and Office Pro+ 2007 12.0.4518.1014

Minimal Data: http://farm4.static.flickr.com/3044/...329e8c22_o.jpg
Less Data: http://farm4.static.flickr.com/3225/...385a4852_o.jpg
All Data: http://farm4.static.flickr.com/3192/...294b3828_o.jpg
 
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
Missing Axis Category Labels CruisJR Charts and Charting in Excel 1 March 29th 07 06:42 PM
axis labels on charts rdale Charts and Charting in Excel 1 August 11th 06 01:31 PM
X-axis labels missing CharlieTuneA Charts and Charting in Excel 1 August 2nd 06 03:28 PM
Excel Charts - Time line for random points on X axis Anjalika Silva Excel Worksheet Functions 2 January 10th 06 09:22 PM
Missing x-axis labels on chart in XL97 Rob Hick Charts and Charting in Excel 2 November 18th 05 05:40 PM


All times are GMT +1. The time now is 03:51 PM.

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"