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 |
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 |
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