Dashboard- serial chart (Clustered Chart)

I need to create a clustered chart in which the Actual columns in the four categories will be fetched using a query and the Planned columns will be explicitly set.
How can I achieve this chart?


Could you clarify how do you get “Planned” values?

The chart component provides the ability to set only one data provider that can contain a property for each graph.
I would suggest adding a transient field (see also MetaProperty) to your entity, and after loading, set the value for each entity.