OWC 11 - Chart bounded - Managing Multiple Charts

[Lucas Campos]

Hi,
How can I manage multiple charts bounded to one Pivot Table and select which
series to chart in each one. It seems to be that charts uses all series. Can
I select which one to use Chart by Chart?
I used to make this with unbounded charts adding the series I like

Thanks

LucasC

 

[Thao Moua [ms]]

A pivotchart will plot ALL the series. To plot only
selected series, check/uncheck the series you want/don't
want from the series dropdown field picker.

Thao Moua
OWC Webchart Support

This posting is provided "AS IS" with no warranties, and
confers no rights. Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

 

[Lucas Campos]

Where can I find this DropDown? Is it possible to plot some series in one
chart and another series in another chart ?

Thanks

 

[Wei-Dong Xu [MSFT]]

Hi Lucas,

Thank you for replying!

For the dropdown list, you will find the dropdown list button by clicking each triangle icon of each field in the PivotTable. After the clicking, there will
pop up one dropdown list for you to specify the series. Furthermore, so far as I know, you can only create one chart for one PivotaTable.

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Lucas Campos]

That's the point. What I was trying to know is the multiple chart
possibilities.
As I could see, I can use multiple Charts for one pivot table in bounded
charts. The problem seems to be that those charts must use the same series
of data and I couldn't choose which series to plot in each chart.

What I'm trying to do is using Pivot Table as a "DataSource" and use
multiple charts selecting "what" and "How" to plot different charts.
I used to do it with unbounded charts (providing data series by code) and I
was trying to know if OWC 11 enhance those features in order to reduce my
custom code. It seems to me that this is not the case, isn't it?

Thanks a lot

LucasC

Hi Lucas,

Thank you for replying!

For the dropdown list, you will find the dropdown list button by clicking

each triangle icon of each field in the PivotTable. After the clicking,
there will

pop up one dropdown list for you to specify the series. Furthermore, so

far as I know, you can only create one chart for one PivotaTable.

 

[Thao Moua [ms]]

Chartspace has a multiple chart feature. The property is
called HasMultipleCharts and is located at the Chartspace
level. Setting this property to TRUE will allow you to
filter and create multiple charts based on your data.

Understand Chartspace will use all the data from the
Pivotlist control so you cannot simplier filter out
individual series you don't want.


Thao Moua
OWC Webchart Support

This posting is provided "AS IS" with no warranties, and
confers no rights. Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

-----Original Message-----
That's the point. What I was trying to know is the multiple chart
possibilities.
As I could see, I can use multiple Charts for one pivot table in bounded
charts. The problem seems to be that those charts must use the same series
of data and I couldn't choose which series to plot in each chart.

What I'm trying to do is using Pivot Table as a "DataSource" and use
multiple charts selecting "what" and "How" to plot different charts.
I used to do it with unbounded charts (providing data series by code) and I
was trying to know if OWC 11 enhance those features in order to reduce my
custom code. It seems to me that this is not the case, isn't it?

Thanks a lot

LucasC




"Wei-Dong Xu [MSFT]" <[email protected]> escribió en el mensaje

Hi Lucas,

Thank you for replying!

For the dropdown list, you will find the dropdown list

button by clicking
each triangle icon of each field in the PivotTable. After the clicking,
there will

pop up one dropdown list for you to specify the

series. Furthermore, so
far as I know, you can only create one chart for one PivotaTable.

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties,

and confers no
rights.

.

 

[Wei-Dong Xu [MSFT]]

Hi Lucas ,

Thank you for replying!

In owc11, I'd suggest you can directly create several chart components in one web page by retrieving data from one pivottable. You can set the
data source of each chart component to the pivottable. This way, you can add, change, or remove fields in the chart by clicking "Field list" on the
chart toolbar.

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Lucas]

Does this solution (using more than one chart component) allow me to show
different data or all of the Charts will affect and be affected by the same
changes. I mean with this, is this a way to show some OLAP measures in one
chart and another OLAP measures in another chart?

Thanks

Lucas C

Hi Lucas ,

Thank you for replying!

In owc11, I'd suggest you can directly create several chart components in

one web page by retrieving data from one pivottable. You can set the

data source of each chart component to the pivottable. This way, you can

add, change, or remove fields in the chart by clicking "Field list" on the

 

[Wei-Dong Xu [MSFT]]

Hi Lucas,

Thank you for replying!

So far as I know, all the charts will be affected if they pointed to one pivotTable.

Please feel free to let me know if you have any further questions.

Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.