Hi guys,
i am trying to put a circle on an excel chart using visual c++.net, the problem i'm having is the circle is filled and i dont want any fill. i have searched the internet for some time and couldnt figure it out. can any one help me please. the code i have used so far is as below to make the line "none" and the markers set as circle. i dont know the objects/properties for setting the circles to no fill. Even solution in vba.net would help as i can try to figure it out for c++.net.
static_cast<Series^>(ch->SeriesCollection(2))->MarkerStyle = XlMarkerStyle::xlMarkerStyleCircle; //sets the markers to circle
static_cast<Series^>(ch->SeriesCollection(2))->Border->LineStyle = XlLineStyle::xlLineStyleNone; //removes the line between the markers
any help would be greatly appreciated.
kind regards,
Mo
i am trying to put a circle on an excel chart using visual c++.net, the problem i'm having is the circle is filled and i dont want any fill. i have searched the internet for some time and couldnt figure it out. can any one help me please. the code i have used so far is as below to make the line "none" and the markers set as circle. i dont know the objects/properties for setting the circles to no fill. Even solution in vba.net would help as i can try to figure it out for c++.net.
static_cast<Series^>(ch->SeriesCollection(2))->MarkerStyle = XlMarkerStyle::xlMarkerStyleCircle; //sets the markers to circle
static_cast<Series^>(ch->SeriesCollection(2))->Border->LineStyle = XlLineStyle::xlLineStyleNone; //removes the line between the markers
any help would be greatly appreciated.
kind regards,
Mo
