Hi Folks,
I'm looking for a way to change the Category axis column labels with one
command, similar to how you would program a series object using the Values
property. I know it can be done as you can do it in the UI, unfortunately I
haven't a Scooby how to do it in code.


Many Thanks
--
Regards
Rob Pollard

My Astro CCD page is:
http://www.robpol.demon.co.uk

Hey Andy,
Thanks!!!!! That does the trick!!! I guess I owe you a few beers!


--
Regards
Rob Pollard

My Astro CCD page is:
http://www.robpol.demon.co.uk

"Andy Pope" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Rob,
>
> This was captured using the Macro recorder.
>
> ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R2C1:R8C1"
>
> or something like this
>
> Dim rngLabels As Range
>
> Set rngLabels = Range("B2:B8")
> ActiveChart.SeriesCollection(1).XValues = rngLabels
>
>
> Rob Pollard wrote:
> > Hi Folks,
> > I'm looking for a way to change the Category axis column labels with
one
> > command, similar to how you would program a series object using the
Values
> > property. I know it can be done as you can do it in the UI,
unfortunately I
> > haven't a Scooby how to do it in code.
> >
> >
> > Many Thanks
>
> --
>
> Cheers
> Andy
>
> http://www.andypope.info
>