Solved

cake charts in excel.

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How can i compile this github project?? 2 91
Windows Service to Receive TCP Packets 4 171
Query group by data in SQL Server - cursor? 3 49
asp Google Map 2 32
This is about my first experience with programming Arduino.
Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
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 …

830 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