LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

excel graph color

Hello,
 
I tried to change the color of a graph in excel.
the graph was created before.
I've got 4 lines and have an array with 4 items connected to Excel_Set_Chart_Colors.vi.
 
has anyone an idea?
 
the error text is:
-2146827284
Unknown System Error in Excel_Set_Chart_Colors.vi->Excel Set Graph Colors.vi->ExcelExport.vi
 
Markus
 
0 Kudos
Message 1 of 7
(2,725 Views)

Hi Markus,

i think you get the error because you don´t insert a graph. If you want to change only the color, then you have to set some internal used refereces, which will be created if you use the "Excel insert graph.vi".

Mike

0 Kudos
Message 2 of 7
(2,720 Views)
Hello Mike,
 
look at the attachment. I created a graph. Or am I wrong?
 
Thanks
 
Markus
0 Kudos
Message 3 of 7
(2,716 Views)
Hi Markus,
yes you are right, but i thought you do not because i get the error you said only if i try to change the color without creating a new graph. Can you upload your code?

Mike
0 Kudos
Message 4 of 7
(2,701 Views)
Hello Mike,
 
in the attachement there is my vi. I modified the vi. But the error is existing.
 
markus
0 Kudos
Message 5 of 7
(2,688 Views)

Hello Mike,

I tried the vi running without a template on the input and it worked.

 

markus

0 Kudos
Message 6 of 7
(2,680 Views)

Hi Markus,

if i use your example and i connect a template file, then it works for me.

Mike

0 Kudos
Message 7 of 7
(2,675 Views)