I want to combine xyline plot with bar plot in excel. I created xyline plot and then added new series with a hope that I can chance the series 1 later.
Step 1: But it turned to be not true, see the results. Particularly misalignment of the axis. created xy line plot:
Step 2: Added line series 2, then changed back the series 1 to bar.
But it turned to be bad:
Any resolution? I need to do this excel, I am using 2007 version. Scripts to fix such problem are welcome.