View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Jeff@HP Jeff@HP is offline
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