(Msg. 1) Posted: Fri Nov 07, 2008 9:36 am
Post subject: Random Missing Axis Labels - Pivot Charts Archived from groups: microsoft>public>excel>charting (more info?)
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
(Msg. 2) Posted: Fri Nov 07, 2008 10:29 am
Post subject: RE: Random Missing Axis Labels - Pivot Charts [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Update: installed Office SP2, problem not resolved.
(Msg. 3) Posted: Fri Nov 07, 2008 1:14 pm
Post subject: RE: Random Missing Axis Labels - Pivot Charts [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi,
To the best of my knowledge there is only an SP1 for Excel 2007 (Office), so
I'm wondering what program you are working with and what version?
--
Thanks,
Shane Devenshire
"Jeff@HP" wrote:
> Update: installed Office SP2, problem not resolved.
(Msg. 4) Posted: Fri Nov 07, 2008 1:30 pm
Post subject: RE: Random Missing Axis Labels - Pivot Charts [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Yes, SP1. I had SP2 on the brain, and typed the wrong thing. Sorry.
(Msg. 5) Posted: Fri Nov 07, 2008 1:51 pm
Post subject: RE: Random Missing Axis Labels - Pivot Charts [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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/3010917474_c0329e8c22_o.jpg > Less Data: http://farm4.static.flickr.com/3225/3010079933_45385a4852_o.jpg > All Data: http://farm4.static.flickr.com/3192/3010917440_48294b3828_o.jpg
(Msg. 6) Posted: Fri Nov 07, 2008 2:46 pm
Post subject: RE: Random Missing Axis Labels - Pivot Charts [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thanks Shane,
Yes, I've tried all that. I've gone to very small fonts and an interval of
1. I wish it was that easy.
(Msg. 7) Posted: Fri Nov 07, 2008 5:55 pm
Post subject: RE: Random Missing Axis Labels - Pivot Charts [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi,
It may be a bug. I will post it to Microsoft if you can supply me with a
copy (with dummy data), if I can't figure out what's wrong.
> 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/3010917474_c0329e8c22_o.jpg > Less Data: http://farm4.static.flickr.com/3225/3010079933_45385a4852_o.jpg > All Data: http://farm4.static.flickr.com/3192/3010917440_48294b3828_o.jpg
(Msg. 8) Posted: Tue Nov 11, 2008 3:37 pm
Post subject: RE: Random Missing Axis Labels - Pivot Charts [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thanks Shane.
I've got a support issue open with MS on it right now. (MSDN membership has
some perks).
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office