S
Sanjeev Srigiri
Hello,
I am having problem to populate the following chart types,
it would be great if anyone suggest me how to get them working
chChartTypeScatterMarkers
chChartTypeScatterSmoothLineMarkers
chChartTypeScatterSmoothLine
chChartTypeScatterLineMarkers
chChartTypeScatterLine
chChartTypeScatterLineFilled
chChartTypeBubble
chChartTypeBubbleLine
chChartTypeStockHLC
chChartTypeStockOHLC
chChartTypePolarMarkers
chChartTypePolarLine
chChartTypePolarLineMarkers
chChartTypePolarSmoothLine
chChartTypePolarSmoothLineMarkers
for all the other chart types I just set the datasource of the chart to
pivot
Set MyChart.DataSource = MyPivotTable
and it works fine, and i play with colors
but, for the above chart types I tired setting the setdata property
for eg for Polar Line chart type , i used the following code, but does't
work
MyChart.SetData chDimCategories, 0, 0
MyChart.SetData chDimThetaValues, 0, 1
like wise I tried for all the problematic charts, but in vein.
can somebody please send me some sample codes for the above charts.
Thanks in advance
Sanjeev
I am having problem to populate the following chart types,
it would be great if anyone suggest me how to get them working
chChartTypeScatterMarkers
chChartTypeScatterSmoothLineMarkers
chChartTypeScatterSmoothLine
chChartTypeScatterLineMarkers
chChartTypeScatterLine
chChartTypeScatterLineFilled
chChartTypeBubble
chChartTypeBubbleLine
chChartTypeStockHLC
chChartTypeStockOHLC
chChartTypePolarMarkers
chChartTypePolarLine
chChartTypePolarLineMarkers
chChartTypePolarSmoothLine
chChartTypePolarSmoothLineMarkers
for all the other chart types I just set the datasource of the chart to
pivot
Set MyChart.DataSource = MyPivotTable
and it works fine, and i play with colors
but, for the above chart types I tired setting the setdata property
for eg for Polar Line chart type , i used the following code, but does't
work
MyChart.SetData chDimCategories, 0, 0
MyChart.SetData chDimThetaValues, 0, 1
like wise I tried for all the problematic charts, but in vein.
can somebody please send me some sample codes for the above charts.
Thanks in advance
Sanjeev