Histogram Charts

[LaurinX]

Hey there,
is there a way to create charts without using data from the worksheet?
I am trying to create a histogram using 2D clustered column chart since its the closest thing to a histogram. My raw data is displayed on the worksheet but i do not want to put the "processed" data (eg. intervals from my raw data for the categories field in formatChartSeries) on the worksheet.
If any of you know a workaround or something please let me know

[xuri]

Creates a chart by AddChart with a data source that references another sheet and hides the data source sheet by SetSheetVisible. Another way is to create a chart sheet by AddChartSheet instead of the AddChart function.