• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 311
  • Last Modified:

cake charts in excel.

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
kotharu
Asked:
kotharu
  • 2
1 Solution
 
aHBeCommented:
Properties are:
 Application
 Count
 Creator
 Parent

 at least in Excel 10 (XP)

cu, ab
0
 
bhagyeshtCommented:
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
 
kotharuAuthor Commented:
Thank you very much bhagyesht.
0
 
bhagyeshtCommented:
glad to be of help.
0

Featured Post

Industry Leaders: 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!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now