PC Review


Reply
Thread Tools Rate Thread

Changing types of charts.

 
 
Axiom
Guest
Posts: n/a
 
      21st May 2004
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

 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      22nd May 2004
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/
>


 
Reply With Quote
 
Axiom
Guest
Posts: n/a
 
      24th May 2004
Thanks a million

Axio

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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shapes: identifying different types (charts, textboxes, pictures e David Macdonald Microsoft Excel Programming 4 11th Nov 2009 02:38 PM
Multiple types of charts in one chart Alan Microsoft Excel Charting 0 6th Aug 2008 10:21 PM
Charts - Custom Types - Line Column - Data Series =?Utf-8?B?U3B5ZGVy?= Microsoft Excel Misc 7 30th May 2007 02:56 PM
Cannot combine stock charts with other chart types in Excel 2007 =?Utf-8?B?cnJy?= Microsoft Excel Charting 1 12th Jan 2007 02:55 AM
Charts Line Types for Multiple Data Series not Printing Properly =?Utf-8?B?U2VhbmI=?= Microsoft Excel Charting 0 22nd Aug 2005 06:35 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:52 AM.