Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating a chart from another on same worksheet.
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating a chart from another on same worksheet.
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating a chart from another on same worksheet.
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating a chart from another on same worksheet.
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating a chart from another on same worksheet.
It was getting late, and I typed it wrong, sorry. That last line should
read: "This puts a linked picture of the copied range into the first sheet." Now I think it tells you how to get what you need. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Alex s" wrote in message ... 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating a chart from another on same worksheet.
Is there a way were I can just print and the chart on the second worksheet
will some how automatically paste on the first worksheet. "Jon Peltier" wrote: It was getting late, and I typed it wrong, sorry. That last line should read: "This puts a linked picture of the copied range into the first sheet." Now I think it tells you how to get what you need. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Alex s" wrote in message ... 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating a chart from another on same worksheet.
I showed how it pastes onto the first worksheet, in such a way as it stays
updated. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Alex s" wrote in message ... Is there a way were I can just print and the chart on the second worksheet will some how automatically paste on the first worksheet. "Jon Peltier" wrote: It was getting late, and I typed it wrong, sorry. That last line should read: "This puts a linked picture of the copied range into the first sheet." Now I think it tells you how to get what you need. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Alex s" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Discussion (Misc queries) | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
How to copy Chart and its data to another excel worksheet | Charts and Charting in Excel | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions |