dynamic percentage computation

[vince]

Hello,

I have a chart that automatically updates itself as new
data is available, comparing revenue level for the first x
days of the month with the previous month.

I would like to automatically display the percentage
increase/decrease next to the serie's value. ex: $10,245
(+15.2%). Since the value is changing every day, I cannot
just create a text box, but would like the percentage to
be computed automatically.

Any idea?

Thx

Vince

 

[Tushar Mehta]

Maybe you can use a data label? If so, calculate the %value in a cell
and use it for the data label. To simplify the use of the data label,
get the XY Chartlabeler from www.appspro.com or the ChartTools from
www.j-walk.com.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions