Sometimes when I highlight a new series on the spreadsheet and drag it
into an existing chart, a pop-up appears giving me various options.
Other times, the new data just gets added to an existing series, which
is not what I want. How can I either get the pop-up to occur every
time, or get the new data to form a new series every time? Thanks for
any ideas.

The easiest option is to copy the series from the data sheet and then go to
the chart and Edit/ Paste Special (rather than dragging) to get the prompt
for selecting a new series.
--
David Biddulph

"Shasbaz" wrote in message
ups.com...
Sometimes when I highlight a new series on the spreadsheet and drag it
into an existing chart, a pop-up appears giving me various options.
Other times, the new data just gets added to an existing series, which
is not what I want. How can I either get the pop-up to occur every
time, or get the new data to form a new series every time? Thanks for
any ideas.

Copy the data, then select the chart and use Edit menu Paste Special to
get the dialog.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Shasbaz" wrote in message
ups.com...
Sometimes when I highlight a new series on the spreadsheet and drag it
into an existing chart, a pop-up appears giving me various options.
Other times, the new data just gets added to an existing series, which
is not what I want. How can I either get the pop-up to occur every
time, or get the new data to form a new series every time? Thanks for
any ideas.