once you have a chart adding data is a nighmare and i still havn't managed to
do it. in excel 2003 you click chart, add data, then select the data usually
with a comma between x and y values, then one simple dialogue then done.

the new one you right click select data (there is no add data), then it
comes up with a box which is for editing the current series. then i click add
data and try to fill out x and y values in the different boxes but it doesn't
come out correctly. maybe it's something to do with row/column but that
option is greyed out.

what a nightmare user interface