Looking for ways to conditionnally add data on a stacked bar chart

[Nikox9]

Hello there,

a have "check boxes" where I can select if a project is active or not (if active (TRUE), will bring some revenue over the coming years - adding up to the other active projects, and if not active (FALSE), the revenue shall not be accounted for)

Assumptions: x-axis = years / y-axis = cumulative revenue
Here is my problem: I don't know how to use the TRUE and FALSE statements to be able to add the revenue of an active project in the graph (stacked bar).

Would somebody be able to help me understand how to achieve this ?

Thanks a lot,
Nicolas.

[JBeaucaire]

I'd suggest making a Pivot Table from the raw data, use the TRUE/FALSE flag to filter the results of the PT. Then link your chart to the Pivot Table instead of the raw data.