O great Thao, wouldest thou help me?

J

Jim.Hubbard

Thao Moua, Master of OWC, wouldest thou help me?



I want to be able to programatically select/deselect categories and
series in an OWC10 chart that I have on a vb6 form.



I think I have the category thing down....



'-----------------------------------------------------------------

Set fldset = pview.FieldSets("category")

' Uncheck the all members

fldset.AllIncludeExclude = c.plAllExclude



Set fld = pview.FieldSets("category").Fields(0)

' Check the members you want - in this case cities in the
'category' column

fld.IncludedMembers = Array("Chicago", "Atlanta")

'-----------------------------------------------------------------





...but I can't seem to figure out how to do the series selection.
Can you offer any insight here?
 
T

Thao Moua [ms]

To select any series,
CS.Charts(0).SeriesCollection(x).Select()

To select any axis,
CS.Charts(0).Axes(x).Select()

To select individual labels on the pivotchart's category,
webchart.charts(0).axes
(c.chaxispositionbottom).CategoryLabels.item
(Index,Level).Select()

Is this what you're looking for?

Thao Moua
OWC Webchart Support
 
J

Jim Hubbard

Almost, I need to be able to deselect them programmatically.

The manual process I need to do programmatically is like this...

If you have a chart in front of you, right-click it and select "Drop
Areas"...then drag one of the series (now showing along the top of your
chart, looking like buttons) off to the right until your item icon (under
your mouse pointer - looks like a blue box with lines up and down it) turns
into a reddish X and release the mouse button.

This will deselect the series item (an item showing in the legend) that you
just dropped away from the chart. This series item will be removed from the
legend and the chart, but it is still in the "Field List" (which you can see
by right-clicking the chart and selecting "Field List") so that you can drag
it from the "Field List" back onto the chart if you wanted to see it charted
again.

I need to be able to do all of this programmatically.

Thanks for the help!

Jim
 
Top