G
Gary Keramidas
i am using the following code to format a chart with a toggle button
With Worksheets("Charts").ChartObjects(1).Chart
.HasTitle = True
.ChartTitle.Text = "First Quarter Sales"
.Type = xlColumn
when the togglebutton changes state, i want the chart to be stacked 100
i tried .type=xlstacked100
but that didn't work. can somebody please tell me what i would use to
accomplish this?
thanks
With Worksheets("Charts").ChartObjects(1).Chart
.HasTitle = True
.ChartTitle.Text = "First Quarter Sales"
.Type = xlColumn
when the togglebutton changes state, i want the chart to be stacked 100
i tried .type=xlstacked100
but that didn't work. can somebody please tell me what i would use to
accomplish this?
thanks