I have this rather stupid litle excel issue which somehow just doesn't go away by itself;
I'm creating a excel chart from three rows of information data. Each row has a header, so far so good. The first row exixt of calender data and I planned it to use them as my x-axis labeling. But somehow excel uses them as variables and changes them in to a third bar. Which is not what I had in mind when copied this litle piece of code.
The code looks like this:
Dim chartPage As Excel.Chart
Dim xlCharts As Excel.ChartObjects
Dim myChart As Excel.ChartObject
Dim chartRange As Excel.Range
xlCharts = oSheet.ChartObjects
myChart = xlCharts.Add(10, 80, 300, 250)
chartPage = myChart.Chart
chartRange = oSheet.Range("M3", "O10")
chartPage.SetSourceData(Source:=chartRange)
chartPage.ChartType = Excel.XlChartType.xlColumnClustered
Can someone give me a hand please, cause MSDN is giving me a splitting headache but no answer. :(
Probably I'm missing something very obvious.
