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
--


Gary

sorry, this is the type i tried:

..type=xlColumnStacked100

--


Gary


"Gary Keramidas" wrote in message
...
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
--


Gary

Gary -

..ChartType=xlColumnStacked100

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Gary Keramidas wrote:
sorry, this is the type i tried:

.type=xlColumnStacked100

ok, thanks

--


Gary


"Jon Peltier" wrote in message
...
Gary -

.ChartType=xlColumnStacked100

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Gary Keramidas wrote:
sorry, this is the type i tried:

.type=xlColumnStacked100