[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

cake charts in excel.

Posted on 2003-11-04
4
Medium Priority
?
305 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 160 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This is about my first experience with programming Arduino.
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
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…

656 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