Hi!
This is a post about a Problem in Excel 2007.
I have a Pivot&Chart thats datasource is a Cube (SSAS).

The Chart displays some values as a columns and another as a line.


The Pivot has got a Filter on the Pivot-Columns.
If I change the Filter, Excel updates the chart values. Thats Ok.

Here the Pivot Filter set to show Values of B and C

| _______________A____ Value A as Line
| ____
| ___| |
| | | B | Value B and C as Column
| | C | |
+-----+- ---+-----+------------




Problem:
Excel also changes the chart type to use only columns if I change the
Pivot-Filter.
It is two columns now. But Value A shall be still a Line!


Filter changed to only show B

| ____
| ____| |
| | | |
| | B | A | Value B
as Column and Value A as Column. But Value A shall be a line!
| | | |
+-----------+-----+------+------


Question:
How can I prevent the Chart Type to be changed if I change the pivot filter???

In Excel we used a Macro, but Macros dont work in Excel Services