Solved

cake charts in excel.

Posted on 2003-11-04
4
277 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
splitOdd10 challenge 5 108
python question 5 76
MacOS and programming in React 7 35
Query Syntax 17 36
This article will show, step by step, how to integrate R code into a R Sweave document
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
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…

809 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