Conditional Format Chart Data Labels

[tg77]

Hi all,

I have a bar chart that feeds off a table that has a drop down option to either show the actual numbers, dollars or percentage.

I'd like to have the data labels in the chart change their number format depending on the table format (either general number, $ or %).

But I'm stuck- any ideas?

I can record a macro, but not well versed in VBA...

Thanks!

Tom