ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Problem with office web components (https://www.excelbanter.com/charts-charting-excel/117349-problem-office-web-components.html)

Jan Hladík

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






All times are GMT +1. The time now is 10:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com