I am using Excel 2007.
I have a table that I would like to move to another location on my sheet.
From that table, a graph is created.
I have selected all the rows and columns in that table,control-c and I have
clicked on the cell where I want to move the table and a control-v and the
table has been moved. But the graph has only a few lines on it.
Can a table be moved to another location on a sheet without re-working the
graph?
Thanks

Hi,

Are you trying to chart the range you are copying with a chart that already
referenced the orginal range? If so maybe you should use Ctrl+X rather than
Ctr+C.
That way the chart will follow the data.

Cheers,
Shane Devenshire

"Charles Eaves" wrote:

I am using Excel 2007.
I have a table that I would like to move to another location on my sheet.
From that table, a graph is created.
I have selected all the rows and columns in that table,control-c and I have
clicked on the cell where I want to move the table and a control-v and the
table has been moved. But the graph has only a few lines on it.
Can a table be moved to another location on a sheet without re-working the
graph?
Thanks

Thanks Shane
That was the solution...
Thanks again!!!!!!!
"Shane Devenshire" wrote in
message ...
Hi,

Are you trying to chart the range you are copying with a chart that
already
referenced the orginal range? If so maybe you should use Ctrl+X rather
than
Ctr+C.
That way the chart will follow the data.

Cheers,
Shane Devenshire

"Charles Eaves" wrote:

I am using Excel 2007.
I have a table that I would like to move to another location on my sheet.
From that table, a graph is created.
I have selected all the rows and columns in that table,control-c and I
have
clicked on the cell where I want to move the table and a control-v and
the
table has been moved. But the graph has only a few lines on it.
Can a table be moved to another location on a sheet without re-working
the
graph?
Thanks