Best way to share an axis for different data fields using the same scale?

[Ayupchap]

all hope someone can help me

I am having trouble showing a line and clustered column chart whereby the shared axis is used for 2 sets of data each using the same scale.  This is what I have:

Field called ELA Goal which is 1, 2 ,3 or 4

Test Results for different tests (2 types in same area) which is also 1,2,3,4

Students who have data for both

There are two tables linked together by student name.  The results currently dont look right as can be seen here.  I know this as the line part is showing the wrong number of each (we only have 650 students and around 450-500 with actual data that should be shown in the line.

Any help much appreciated!

[v-sihou-msft · Accepted solution]

@Ayupchap

In this scenario, the reason why the line shows higher values is that the count of students names are aggregated on ELA Goal level (for both type). However, it's not possible to have line sliced by the column series which separates into multiple lines in this kind of combine chart. So I suggest you show the count of students in another chart and make it sliced my different type of tests.

Regards,

[Ayupchap]

Thanks so much!  That does make sense.