I seem to be missing some obvious way to add new data series to an xy chart. It seems to dump a previous series when I add a new one.

I am trying to work in the most basic XY Chart mode. Let’s say I have a column of data that gets broken up into separate segments (Y axis) and a parallel column of values that provide the X axis. The add series box seems to allow putting an additional series into place, but tends to blow away the first set. There also seems to be very limited ability to edit labels (all forced to lower case).

Is there a tutorial that covers these basic issues?

Chart Wizard - Data Series

Chart Wizard - Data Range