One pivot chart as the bottom chart and another one is the top chart only view single column through Slicer but the same data two charts, then two charts were aligned as center and middle, the second chart was a highlight. if we will delete the horizontal category axis and vertical category axis variance show
so, second chart horizontal category axis text is "No Fill" and vertical category axis text is "No Fill" so, require macro code for this
Excel File enclosed for the macro run - excel_chart_line_vs_dots_macro_work