Has anyone been successful in setting a custom axis format on a pivot chart?
I don¹t seem to be able to get this to work.

Thanks for suggestions.

Hi Greg,

I don't have any problems with this, could you give us the details.
--
Thanks,
Shane Devenshire


"Greg McCarter" wrote:

Has anyone been successful in setting a custom axis format on a pivot chart?
I don¹t seem to be able to get this to work.

Thanks for suggestions

On Mon, 19 May 2008, in microsoft.public.excel.charting,
Greg McCarter said:
Has anyone been successful in setting a custom axis format on a pivot
chart? *I don?t seem to be able to get this to work.

Do you mean number formats, or customised arbitrary axes? Special custom
axes tend to be constructed using scatter series, which I think pivot
charts don't do. You just have to use an ordinary (non-pivot) chart to
get what you want. Pivot charts are quick and easy off-the-shelf
solutions, not for customising.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Hi again,

In 2003 and earlier, some custom formats are not retained on refresh, maybe
that is the problem?
--
Cheers,
Shane Devenshire


"Greg McCarter" wrote:

Has anyone been successful in setting a custom axis format on a pivot chart?
I don¹t seem to be able to get this to work.

Thanks for suggestions

Yes I have so much trouble with this "some custom formats are not retained on
refresh". Is it fixed in 2007 version?
--
====================
ask and you shall be answered


"ShaneDevenshire" wrote:

Hi again,

In 2003 and earlier, some custom formats are not retained on refresh, maybe
that is the problem?
--
Cheers,
Shane Devenshire


"Greg McCarter" wrote:

Has anyone been successful in setting a custom axis format on a pivot chart?
I don¹t seem to be able to get this to work.

Thanks for suggestions