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.