Hi I'm currently trying to output three different Excel graphs to three different sheets in an Excel document. Currently the function creates a graph and places it into the Excel file on the correct sheet I've assigned it using the function "xlLib.SelectSheet". However when the function runs again and the program passes a different sheet name to the "xlLib.SelectSheet" function it just overwrites the graph on the first sheet. Any ideas?
Thanks!
Tim
Thanks!
Tim
Would you like to try below? Go into Create Chart user object, check the Line Chart Settings and input the desire sheet name into ChartSheet field.
Hope this helps
MK