ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   I would like to: (https://www.excelbanter.com/charts-charting-excel/210842-i-would-like.html)

Charles Eaves

I would like to:
 
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



Shane Devenshire[_2_]

I would like to:
 
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




Charles Eaves

I would like to:
 
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







All times are GMT +1. The time now is 08:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com