Hi Leith,

have the
chart in column "A". Is this right?

ActiveChart.Location Whe=xlLocationAsNewSheet

would indicate she wants the chart on a new chart sheet.

--
Regards,
Tom Ogilvy

"Leith Ross" wrote
in message ...

Hello Ruth,

When I read your post I wasn't really certain if you wanted to choose
the cells for the chart's location or the chart's input data. It sounds
like you want to be able to select the input data range and have the
chart in column "A". Is this right?

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=479340