Chart series value problem
Posted: Sat Jun 23, 2007 8:58 am
Hi,
XLS.Sheets[0].Charts[0].Series[0].Values := 'Sheet1!$B$6:$B$20';
it is code run no problem,
It is code not running
XLS.Sheets[0].Charts[0].Series[0].Values := 'Sheet1!$B$6;Sheet1!$B$7;Sheet1!$B$10';
ShowMessage('Series value : '+XLS.Sheets[0].Charts[0].Series[0].Values);
Sheet1!$B$6
What problem
XLS.Sheets[0].Charts[0].Series[0].Values := 'Sheet1!$B$6:$B$20';
it is code run no problem,
It is code not running
XLS.Sheets[0].Charts[0].Series[0].Values := 'Sheet1!$B$6;Sheet1!$B$7;Sheet1!$B$10';
ShowMessage('Series value : '+XLS.Sheets[0].Charts[0].Series[0].Values);
Sheet1!$B$6
What problem