thanks Ragdyer.
It doesn't solve my problem because I have numbers with decimal less than 1
which should be formated as decimal not as percentual. What I want to do is
make a type of format condition for number in order to have:
if A1="Amount of money" then column A will be formated as 0,000
if A1="Percentage of total" then column A will be formated as 0.00%
thanks for your help

"Ragdyer" wrote:

Can't help you with charting, but if your version of XL is later then XL97,
you could try this custom format:

[=1]#,###;#%

You must also go to:
<Tools <Options <Edit tab,
And make sure that "Enable Auto Percent Entry"
is *UNCHECKED*

This will display numbers *less* then 1 as percents, and all others as
regular numbers without decimals.
If you think that there might be a possibility that you might have values of
100%, then change the format to this:

[1]#,###;#%


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"avjunior" wrote in message
...
Sorry, let me add something....
I also would like to have the "y" axis of the graph, changing format
according to the results as well (e.g. %, 0,000, etc).
thanks

"avjunior" escreveu:

Let's suppose I have 2 sheets in a worksheet.
Sheet 1 is a entry form (dropbox for example)
The source of the dropbox are fields of numbers in different
formats
(e.g: %; 0,000, etc)
Sheet 2
This is where the numbers are going to after the user selection. So
I
would like to have, for example the following results:
result a)
BRANCH TOTAL
A 1,000
B 45,000

result b)
BRANCH PERCENTAGE
A 44%
B 51%

Note that in result a) I need the cells to be formated as 0,000 and
result
b) I want the cells formated as %.

So the question is:
How can I have a cell change its number format based on a condition?

thanks