chart help please

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top