Add calculated dimension via a macro

[Anonymous]

Hi,

I currently have the following which works:

chart.AddDimension "ScatterDate"

And now I am trying to add a calculated dimension like so:

chart.AddDimension "=Date(ScatterDate)"

However, this does not work, nothing is added to the chart.

Any assistance willl be greatly appreciated.

KInd Regards

Dreamer78692

[er_mohit]

chart.AddDimension "=Date(ScatterDate,'DD-MM-YYYY')"

or whatever format you want write that

hope it helps

[Anonymous]

Hi,

Thanks for the response.

It is still not being added to the chart.