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.
Step1: 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.