DataTable number format
 

Hi,

I have a chart that I populate from arrays thru VBA code. The DataTable for
the chart shows the values as they are entered in the array. Is there a way
to have the values in the DataTable shows in the format "0.00%"?? please help!

I tried to use the FormatPercent function, the NumberFormat function, Format
function..etc. with no success.
Any help will be greatly appreciated.
Thanks,
MB

DataTable number format
 

This didnt work (after selecting the cells):
Selection.NumberFormat = "0.00%"

DataTable number format
 

I am not reading from cells but reading from arrays!

"Chip" wrote:

This didnt work (after selecting the cells):
Selection.NumberFormat = "0.00%"