different sources for 2 charts

[#1]

In this example , can I link the left chart to the whole selection box elements group (Codecli + Activité) and the chart on the right side only to 'Activité' ??? (I can do that with XL 2010 and PIvotCharts/segment but I don't know how to make that with QV...)

[Miguel_Angel_Baeyens · Accepted solution]

niko7174 wrote:In this example , can I link the left chart to the whole selection box elements group (Codecli + Activité) and the chart on the right side only to 'Activité' ???

I'd do that using an expression looking like the following

Sum({< CODECLI = >} CA)

So any selection done in CODECLI field will be ignored in that chart.

Hope this helps

[#3]

thank you Miguel

that whorks !

[#4]

I've got now another problem to solve :

On the chart on the right side , the 'B' is in purple colour , whereas it's brown on the left .

If I go to the property , the colours are set in an order , can I assign a colour to a value ?

My goal is to compare two charts .................

[Miguel_Angel_Baeyens]

Hello,

Go to the chart properties in both charts, tab Colors and check "Persistent Colors". That will keep the same values with the same colors.

Hope this helps.

[#6]

Ok , that works .

Thank you Miguel