to many dimensions

[Anonymous]

Hi,

I am having some issues with too many dimensions in the same chart.

As you can see in the attachment, I have a chart with Month (dim1) and TypeofCustomer (dim2). Then in the expression I have the sum of Revenues for 2014 (exp1).

When I try to add the cumulative for 2013 (exp2) and for 2014(exp3) the chart just explodes (see attachement 'explodes').

How can I manages this: having dim1 and 2 and all 3 exp in the same chart?

Any suggestions?

Tx

[Gysbert_Wassenaar]

You can't in one chart. What you can try is put two charts on top of each other and making the background and axes of the top chart transparent.

[JonnyPoole]

agree with below.  Here is a sample i created awhile back to show a 2 dimension x 2 expression line chart. Its not doable short of an extension object, so it actually consists of 2 charts strategically layered over top of each other with the top chart having a  transparent background.

It sort of works buts its kind of annoying. Let me know if you have any questions