M
mbobro
Hi,
I have prepared a bundle of column that has one XY scatter plot serie
It works great, updates with VBA, no problem.
Now I was asked to add one additional point in each serie to the char
with some calculations. Although looked to be be very easy job, it'
not, as the file get corrupted while modyfing the data source for thi
chart using the MS chart interface. I've tried to put the modificatio
into the command line and it works for the chart. Unfortunately it doe
not record while macro recoding ('Macro recording not possible' error
that is essential to update automatically the whole bundle of charts.
I tried to copy all the cells into a new workbook. I tried restartin
my computer. No effect.
I use MS Excel 2002 and Win XP.
Any ideas?
Regards,
Micha
I have prepared a bundle of column that has one XY scatter plot serie
It works great, updates with VBA, no problem.
Now I was asked to add one additional point in each serie to the char
with some calculations. Although looked to be be very easy job, it'
not, as the file get corrupted while modyfing the data source for thi
chart using the MS chart interface. I've tried to put the modificatio
into the command line and it works for the chart. Unfortunately it doe
not record while macro recoding ('Macro recording not possible' error
that is essential to update automatically the whole bundle of charts.
I tried to copy all the cells into a new workbook. I tried restartin
my computer. No effect.
I use MS Excel 2002 and Win XP.
Any ideas?
Regards,
Micha