One Last Time...Clarification Please

[Jim Hubbard]

Some of my people wanted me to make sure that you understood the request. I
insisted that you did, but here goes one last time. After this I will not
bother you with this line of questioning again.

When a user is looking at an OWC10 chart, the user can right click on the
chart and check Drop Areas and Display Fields. The fields in the Field List
will show along the top of the chart and in the Field List as bold entries.
The user can then drag Fields off of the chart and they disappear from the
chart and legend, but remain in the Field List - only now they are not bold.

The user can then drag and drop these fields (those that the user dragged
off the chart and are no longer showing on the chart or in the legend and
are now showing as unselected in the Field List) from the Field List back
onto the chart and they will re-appear in the chart and the legend and will
be boldfaced in the Field List.

Is there a way to do all of this programmatically?

Thanks so much for your patience and sharing your expertise.

Jim Hubbard

 

[Dan Ricker]

There is a way to do this programmatically. Both with the
Chart Object Model and the ChartSpace.InternalPivotTable
PivotTable Object Model. Most of my knowledge is about
the PivotTable so I prefer the
ChartSpace.InternalPivotTable method.

The object models are described in the OWCVBA10.chm file
typically located at:

C:\Program Files\Common Files\Microsoft Shared\Web
Components\10\1033\OWCVBA10.CHM

I will also typically place the OWC control(s) on a
VB/VBA form to get online help and immediate window
capabilities for testing out code. If you don't have VB,
Excel Forms provide a nice VBA environment for learning
about the controls.

Dan

 

[Jim Hubbard]

Thanks for the tip, Dan.

Jim

There is a way to do this programmatically. Both with the
Chart Object Model and the ChartSpace.InternalPivotTable
PivotTable Object Model. Most of my knowledge is about
the PivotTable so I prefer the
ChartSpace.InternalPivotTable method.

The object models are described in the OWCVBA10.chm file
typically located at:

C:\Program Files\Common Files\Microsoft Shared\Web
Components\10\1033\OWCVBA10.CHM

I will also typically place the OWC control(s) on a
VB/VBA form to get online help and immediate window
capabilities for testing out code. If you don't have VB,
Excel Forms provide a nice VBA environment for learning
about the controls.

Dan