LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Problem with office web components

Hi,
I have problem with office web components. I use PivotTable and ChartSpace
objects.
Into PivotTable I have four columns and ChartSpace is connect to PivotTable.
(myChartSpace.DataSource = myPivotTable)

When I run the application PivotTable shows columns. Chart shows
SeriesCollection of this columns.

I want to show only two of four columns in Chart. I try to delete
SeriesCollection.

myChartSpace.Chart(0).SeriesCollection.Delete(2);
myChartSpace.Chart(0).SeriesCollection.Delete(3);

But this doesn`t work.

I dont know if is this possible, when is ChartSpace connect to PivotTable.
When I try Add new SeriesCollection and then Delete, that it work.

Thanks for your help.
Jan




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem starting Office XP SP3 after system restore Peter van der Donk Setting up and Configuration of Excel 1 October 22nd 06 03:59 AM
Is Office Clipboard shared between users or just applications? Paladin Excel Discussion (Misc queries) 0 January 12th 06 07:31 PM
Excel keeps crashing when I try to format any cells? AFlatt Excel Discussion (Misc queries) 21 November 16th 05 06:54 PM
how do I make a word typed in a cell go to a specific cell in anot Lmatarazzo Excel Discussion (Misc queries) 3 April 21st 05 04:29 AM
Running mixed Office components Bernie Wienhold Excel Discussion (Misc queries) 2 January 25th 05 10:23 PM


All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"