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