Solved

cake charts in excel.

Posted on 2003-11-04
4
266 Views
Last Modified: 2008-03-10
In the statement ....Charts("Chart1").SeriesCollection(1).Points(1).
i want to know all the properties eligible for the above command after points(1).

Thanks in advance
0
Comment
Question by:kotharu
  • 2
4 Comments
 

Expert Comment

by:aHBe
ID: 9678458
Properties are:
 Application
 Count
 Creator
 Parent

 at least in Excel 10 (XP)

cu, ab
0
 
LVL 9

Accepted Solution

by:
bhagyesht earned 40 total points
ID: 9684895
try pressing f1 on points this should give u the properties
sorry i installed sp4 on my pc and all the help links are gone! dissabled but this is how u can get the code assist

instead of
    Charts("Chart1").SeriesCollection(1).Points(1).
give

    Dim mypoint As Point
    Set mypoint = ActiveChart.SeriesCollection(1).Points(3)

now when u give mypoint. you shall get the dropdown of all the properties and methods.
0
 

Author Comment

by:kotharu
ID: 9685394
Thank you very much bhagyesht.
0
 
LVL 9

Expert Comment

by:bhagyesht
ID: 9685417
glad to be of help.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
word0 challenge 3 78
oracle query help 18 99
Scripting vs. Programming languages 25 152
Customizing meta title for 404 page template in WordPress' TwentySixteen theme 2 74
Here we come across an interesting topic of coding guidelines while designing automation test scripts. The scope of this article will not be limited to QTP but to an overall extent of using VB Scripting for automation projects. Introduction Now…
Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now