Pivot Chart Data Binding

[heey]

Hi,

I am using OWC10 for this project.

Is there any idea how can i bind the data according the the chart click
event?

I am using this code but is just can bind the data as year 2005, it cant get
year 2005, quarter 1.

Here is my code.

<script language="vbs">

dim sarrMemberShow(1)
sarrMemberShow(0) = ptA_Chart.charts(0).Axes(chConstants.chAxisPositio
nCategory).CategoryLabels(ptA_Chart.Selection.Inde x,0).Caption

ptB.ActiveView.FilterAxis.FieldSets("Time").Fields ("Year").IncludedMembers
= sarrMemberShow

ptB.ActiveView.FilterAxis.FieldSets("Time").AllInc ludeExclude =
ptB.Constants.plAllExclude


Since i get the sarrMemberShow according to te index
0(ptA_Chart.Selection.Index,0), so i just can get the year 2005.

Is there anywhere to get the databinding where i can get the data as year
2005, quarter1?


Thanks for you help.

 

[Alvin Bruney [MVP]]

You'd need to re-arrange your data to display quarters instead of years and
bind to that. You can add this functionality based on end-user selection -
for example a button that says 'draw quarter'.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin