Combo Chart -Line Data is not shown in the "See Data"

[KTP_UBS]

Hello, I have created a combo chart. However, the line data ("Total Grant" ) is now shown in the "See Data" option (see screenshot below). Could you please advise?

[Eric_Zhang · Accepted solution]

@KTP_UBS

The line values' abensence in the see data matrix is due to the different aggregation granularity.

In this case, the line values(total grant) are aggreagted by year while the total budget are by year and project category. So they can't be present in the same matrix.

If you'd like them in the same matrix, remove the project category from the "column series".

For any question, feel free to let me know.