View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Alex s Alex s is offline
external usenet poster
 
Posts: 8
Default Separating a chart from another on same worksheet.

The only problem I have with copying the table by using the Paste Picture
Link is that I need to input information in the second worksheet. If I create
a table on a second worksheet, I'll need a way for both tables to show up on
1 page when I print it out.

"Jon Peltier" wrote:

All cells in a row must have the same height. You can make some cells a
multiple of a row's height if you merge a vertical set of cells, but that's
problematic.

However, you can make the second table in another sheet, then copy the
table, go back to the first sheet, hold Shift and click on the Edit menu,
and select Paste Picture Link. This puts a linked picture of the copied
range into the second sheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Alex s" wrote in message
...
Well I need them to be next to each other. I am making these charts from a
print that I have so I need the charts to be exactly like my print.

"kassie" wrote:

Only way is to make your chart in Columns A:G, below the previous chart.

"Alex s" wrote:

I am creating a chart using columns A-G. All the rows on this chart are
going
to have the same row height. However, in row H, I want to make another
chart
but the height for the rows in this column will vary and will be
different
from the rows in columns A-G. I don't want the height of the rows in
column H
to mess up the row height of columns A-G.

If anybody could help, I would really appreciate it.
Thanks