G
gopal_a00
I'm trying to set multiple categories from an XML data
source. Is this possible? Documentation below sounds like
I can specify only one column name on SetData()
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/off2000/html/ocobjWCSeriesCollection.asp
Pl. let me know if there is a workaround.
Thanks,
Gopal
Code snippet:
cht.type=19
With Cht.SeriesCollection.Add
.SetData c.chDimCategories, 0,"Zip" 'Want to specify
multiple columns here
.SetData c.chDimValues, 0,"Total_Sales_Amount"
Set oLabels = .DataLabelsCollection.Add
oLabels.HasValue = False
oLabels.HasPercentage = True
end with
source. Is this possible? Documentation below sounds like
I can specify only one column name on SetData()
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/off2000/html/ocobjWCSeriesCollection.asp
Pl. let me know if there is a workaround.
Thanks,
Gopal
Code snippet:
cht.type=19
With Cht.SeriesCollection.Add
.SetData c.chDimCategories, 0,"Zip" 'Want to specify
multiple columns here
.SetData c.chDimValues, 0,"Total_Sales_Amount"
Set oLabels = .DataLabelsCollection.Add
oLabels.HasValue = False
oLabels.HasPercentage = True
end with