Dynamic formatting of labels in Excel.....is it possible??

[Mark McInerney]

Hi,

I have a range of dynamic data - I have a formula that returns the euro difference between two sets of numbers, however, I can change this to return the percentage difference between the numbers.

In short the numbers in my resultant range are either € values or percentage values.

I am them graphing this range of data - is there a way to change how the numbers are formatted on the graph - so as they are % when I need them to be, and Euro values on the other occasions?

Any help appreciated.

Best - Mark.