Changing types of charts.

  • Thread starter Thread starter Axiom
  • Start date Start date
A

Axiom

I am new to vb. So please bear with me. I thought that I could jus
change the type of chart to plot and excel would comply. What did I d
wrong and how can I fix it?

With WS.ChartObjects.Add _
(Left:=100, Width:=375, Top:=75, Height:=225)
*.Chart.ChartType = xlBar*
.Chart.SetSourceData Source:=WS.UsedRange
End With

So I changed the xlBar from xlpie. It likes the pie one, but error
out on the xlBar one

-Axio
 
xlBar isn't a valid chart type constant. If you used xlBarClustered or
xlBarStacked, you'd already have your chart.

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