Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding a SparkLines with VB script

Dear Team,

i am making a sparklines with a VBScript in a Excel. Below are the line which i used for same after the Excel export in Excel

xlApp.ActiveSheet.Range("$T$3:$T$10").SparklineGroups.Add Type:=xlSparkLine, SourceData:="K2:L10"

above line giving me Syntax Error

i also have try below mention also

xlApp.ActiveSheet.Range("$T$3:$T$10").SparklineGroups.Add XlSparkType.xlSparkLine,xlApp.ActiveSheet.Range("K3:L10")

this is also not working.

Kindly help.

Regards,

JKV

1 Reply
Not applicable
Author

did any one have any idea how to use sparkline in vbscript