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

--
Message posted from http://www.ExcelForum.com

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

Axiom < wrote:

> I am new to vb. So please bear with me. I thought that I could just
> change the type of chart to plot and excel would comply. What did I do
> 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 errors
> out on the xlBar one
>
> -Axiom
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Thanks a million

Axio

--
Message posted from http://www.ExcelForum.com