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

Try selecting the data and drag it onto the chart or copy the new data, click
on the chart and then click paste. You might need to use paste special if
the resule is not what you want
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"willyhoops.com" wrote:

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

Hi John,

Note drag & dropping of data on to charts has been deprecated in xl2007.

Cheers
Andy

john wrote:
Try selecting the data and drag it onto the chart or copy the new data, click
on the chart and then click paste. You might need to use paste special if
the resule is not what you want

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

thats fine if you have your data on the same page in columns next to each
other ect but i ussually have an xy scatter with each line coming from data
on different pages. for me i think the simplest way to add data to a chart is
to insert a new series but leave the boxes at the default. then goto the
chart page and select the new series which comes up as a dot somewhere, then
manually change the formula to point to my desired data. it's only something
i can going to need to do when working with data ranges too bit to fit into
excel 2003!

"john" wrote:

Try selecting the data and drag it onto the chart or copy the new data, click
on the chart and then click paste. You might need to use paste special if
the resule is not what you want
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"willyhoops.com" wrote:

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