> > On 4/9/08 11:21 PM, in article ee88c11.174@[EMAIL PROTECTED]
"Jake
> > Oliver" wrote:
> >
> > > Does anyone know when an update will come out that will allow us to
change the
> > > x axis labels for Excel 08??
> > >
> > > It is stuck on the standard integer scale.
> > > Is there anyway to select data for the x scale like in office
07!?!?!
> > No, we do not know when (or if) this will be changed. Have you looked
in the
> > chart formatting section of the formatting palette from the tool box?
> >
> > --
> > Bob Greenblatt [MVP], Macintosh
> > bobgreenblattATmsnDOTcom
> >
> >
> Actually you can change the x-axis labels. It's written somewhere in
this or in another post but you have to do it manually in the formula bar.
> This option is not (yet) accessible via the menu/toolbox.
>
> Edit:
>
> I have found the following solution on another forum (after wasting more
than an hour on this):
>
> here's how to do it (explanation courtesy of Bob Greenblatt, there's no
way I could have figured this out on my own!):
>
> To specify a range of cells as the labels on the X axis, click on one of
the data series in the chart (for example, click on one of the colours in a
bar chart).
>
> When you do, you will see a range appear in the floating formula bar. In
my case, the range in the formula bar was:
>
> =SERIES(Summary!$A$5,,Summary!$B$5:$R$5,3)
>
> The space between the two commas is where the X axis labels are
specified. In my case, for whatever reason, Excel didn't pick up the
labels when I created the chart. I added the range of cells containing the
X axis labels (cells B3 through R3) like so:
>
> =SERIES(Summary!$A$5,Summary!$B$3:$R$3,Summary!$B$5:$R$5,3)
>
> Problem solved!
>
> The challenge, of course, will be to remember how to do this in a few
weeks. I can't believe that MS figured that was easier than the old way
(where there was a clearly-labelled field in which a user could specify
the range). :eyeroll: :eyeroll: :eyeroll: :eyeroll:
Thank you, thank you, thank you! this was driving me CRAZY - I'm so glad
you found this an published it!
|
