Thank you very much. It works perfect
I didn't expect such a professional answer.

I also had problem when I tried to add new data. The original series "axis" and "spectrum" are lost if I select a range I wan't to plot. Otherwise I must add them one row at a time

How did you "series plotted as a bar chart" include additional series and changed it to bar chart? I also can't find all those advanced axis configurations.

I work with office 2007.