Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Missing Axis Category Labels | Charts and Charting in Excel | |||
axis labels on charts | Charts and Charting in Excel | |||
X-axis labels missing | Charts and Charting in Excel | |||
Excel Charts - Time line for random points on X axis | Excel Worksheet Functions | |||
Missing x-axis labels on chart in XL97 | Charts and Charting in Excel |