Got it. You can do this when moving to a sheet not a chart sheet.

Thanks.

"David Biddulph" wrote:

If you are trying to add an extra data series to an existing chart, you
don't do it with Insert Chart. Copy the data, then select the chart & Edit/
Paste Special to add the new series.

If you are trying to put more than one separate chart on a worksheet, rather
than more than one series in a chart, then make sure that when the wizard
asks you where you want the chart you tell it to put it as an object on an
existing WORKSHEET, rather than letting it create a new CHART SHEET. If
this is what you are trying to do and it is already on a separate chart
sheet, right-click on the chart should give you a "Location" option, which
allows you to shift between a dedicated chart sheet and an object on a
worksheet.
--
David Biddulph


"rrupp" wrote in message
...
How, then, because when I do it, the new graph/chart over-rides the one
that
is existing. Is there a setting to change? I go through the same steps
as I
did in 2003, I create the chart, when it asks where to put it, I say in
chart
1 and it says do you want to override the chart, I say no. So, it doesn't
allow me to do it. If you can do it, please tell me how.

Please advise. Thanks so much!

"trip_to_tokyo" wrote:

I have just tested this and, in EXCEL 2007, from the same underlying
data, I
have created both a Column Chart and a Line Chart so the answer to your
question appears to be yes.

If my comments have helped plese hit Yes.

Thanks.

"rrupp" wrote:

When using Excell 2007, when I create a graph and place it in a new
sheet, it
works fine. But, what I'd like to additionally do is create another
graph
and place it on that same sheet. Excel 2007 over-rides the first
graph. I
finally just copied and pasted the other graph on to the sheet but can
you
insert multiple graphs on one sheet, without copying/pasting, without
it
over-riding the other graph(s)?

Thanks for your time.


.