Move a total line to above a cluster column chart

[STIBBS_807]

I have a chart with three items showing in the column values.  I want to show a total for the columns in a trend line.  I have set up the chart as a cluster with the totals as the Line value.  I would like the line value to appear above my data.  Does anyone know how I can do this?

MonthYear,Case Reference,Case Type,Case ID,Total Active Cases
Apr-17,2505347,Investigation,1,1
Apr-17,2505857,Investigation,1,1
Apr-17,2507032,Ongoing,1,1
Apr-17,2827187,Investigation,1,1
Apr-17,2838669,Investigation,1,1
Apr-17,2846111,Investigation,1,1
Apr-17,2890638,Intake,1,1
Apr-17,2898020,Intake,1,1
Apr-17,2508300,Ongoing,1,1
Apr-17,2508303,Ongoing,1,1
Apr-17,2508558,Ongoing,1,1
Apr-17,2508816,Ongoing,1,1
Apr-17,2509070,Ongoing,1,1
Apr-17,2509085,Ongoing,1,1
Apr-17,2509573,Ongoing,1,1
Apr-17,2509832,Ongoing,1,1
Apr-17,2509835,Ongoing,1,1
Apr-17,2509838,Ongoing,1,1
Apr-17,2509847,Ongoing,1,1
Apr-17,2510097,Ongoing,1,1
Apr-17,2510354,Ongoing,1,1
Apr-17,2510616,Ongoing,1,1
Apr-17,2510619,Ongoing,1,1
Apr-17,2512148,Ongoing,1,1
Apr-17,2787372,Investigation,1,1
Apr-17,2795238,Ongoing,1,1
Apr-17,2815690,Investigation,1,1
Apr-17,2876374,Intake,1,1
Apr-17,2894629,Intake,1,1
Apr-17,2722469,Investigation,1,1
Apr-17,2724411,Investigation,1,1
Apr-17,2784534,Investigation,1,1
Apr-17,2809361,Investigation,1,1
Apr-17,2828307,Investigation,1,1
Apr-17,2864299,Investigation,1,1
Apr-17,2902633,Investigation,1,1
Apr-17,2869835,Intake,1,1
Apr-17,2869851,Intake,1,1
Apr-17,2869860,Intake,1,1
Apr-17,2869863,Intake,1,1
Apr-17,2869875,Intake,1,1
Apr-17,2901585,Intake,1,1
Apr-17,2876833,Intake,1,1
Apr-17,2797283,Intake,1,1
Apr-17,2820140,Intake,1,1
Apr-17,2820674,Intake,1,1
Apr-17,2827282,Intake,1,1
Apr-17,2827328,Intake,1,1
Apr-17,2837281,Intake,1,1
Apr-17,2840492,Intake,1,1
Apr-17,2851716,Intake,1,1
Apr-17,2887773,Intake,1,1
Apr-17,2890889,Intake,1,1
May-17,2505347,Investigation,1,1
May-17,2505857,Investigation,1,1
May-17,2507032,Ongoing,1,1
May-17,2865873,Investigation,1,1
May-17,2901580,Investigation,1,1
May-17,2915962,Investigation,1,1
May-17,3223292,Intake,1,1
May-17,3242942,Intake,1,1
May-17,3244959,Intake,1,1
May-17,3245913,Intake,1,1
May-17,3248298,Intake,1,1
May-17,2509058,Ongoing,1,1
May-17,2509061,Ongoing,1,1
May-17,2819960,Ongoing,1,1
May-17,2511884,Ongoing,1,1
May-17,2507272,Ongoing,1,1
May-17,2508293,Ongoing,1,1
May-17,2509844,Ongoing,1,1
May-17,2782902,Ongoing,1,1
May-17,3237265,Intake,1,1

[AlexisOlson · Accepted solution]

You can manually set the range of your second y-axis but that isn't great for dynamic interactions.

[v-easonf-msft · Accepted solution]

Hi, @STIBBS_807 

Go to  visual "Format" pane ->Y axis, enable "show secondary", then you can set the start of  Y-axis(line).

Best Regards,
Community Support Team _ Eason

[AlexisOlson · Accepted solution]

You can manually set the range of your second y-axis but that isn't great for dynamic interactions.