I would like to:

C

Charles Eaves

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
 
S

Shane Devenshire

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Create a chart from a table in word thats dynamic 0
Setting column width in a table with a macro is not working 0
Creating a Chart on form from selected data in query. 0
Dates In Excel 5
sqlite-odbc write conflict 2
Plotting Graph with dynamic table 3
Spell Check issue 2

Top