I have found that if there are too many points that I have problems
displaying the labels at various levels. Unfortunately, I don't have your
data to test. You can try smaller font. Sometimes choosing Format Axis, Axis
Options, Specify interval unit set to 1 works better than Automatic.

--
Thanks,
Shane Devenshire


"Jeff@HP" wrote:

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