set chart color in excel

[WeberM]

Hello,

i hope someone can help me.

i had to set the colors of chart in excel from LV.
does someone know how to do this?


markus

[Norbert_B]

Markus,

you propably should ask Microsoft on that one.
Nevertheless, there is an easy way to solve this: I think that you already use ActiveX to communicate with Excel. If you want to change properties of Excelsheets via ActiveX, the best solution is:
Create a makro (using the recording functionality of Excel) which does exactly the desired and then port the makro to LabVIEW......

hope this helps,
Norbert B.