ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   OWC chart: multiple totals and OLAP (https://www.excelbanter.com/charts-charting-excel/31624-owc-chart-multiple-totals-olap.html)

Dima

OWC chart: multiple totals and OLAP
 
Hi!

OWC chart is connected to MS AS
I'd like to display several totals (measures) on the same chart in order to
see 2 lines
I use
objPChart.SetData objPChart.Constants.chDimValues, 0, "v1"
objPChart.SetData objPChart.Constants.chDimValues, 0, "v2"
And I see only v2 line
I use
objPChart.InternalPivotTable.ActiveView.DataAxis.I nsertTotal .Totals("v1")
objPChart.InternalPivotTable.ActiveView.DataAxis.I nsertTotal .Totals("v2")
and nothing changes :-(

Somebody knows how to display several lines at the same chart????

some limitations: OWC is connected to MS analysis services, I'd like to
display different measures (seen under the Totals)

Thanks in advance





All times are GMT +1. The time now is 09:12 AM.

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