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.