If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a chart based on the data in an embedded worksheet
Hi,
I have a worksheet with several embedded worksheets. I would like to create a chart based on the data of one of the embedded worksheets without putting the chart in the embedded worksheet. I have tried unsuccessfully to do this. I just wondered if anyone knew how to do it. Thanks, JK |
#2
|
|||
|
|||
JK -
You're embedding worksheets within worksheets? Why? Why not just insert the worksheets in line with the main worksheet? To open or edit the embedded worksheet, the parent Excel has to open another instance of Excel, and the chart on the outside of this other instance will never be able to access the data across this barrier. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ JK wrote: Hi, I have a worksheet with several embedded worksheets. I would like to create a chart based on the data of one of the embedded worksheets without putting the chart in the embedded worksheet. I have tried unsuccessfully to do this. I just wondered if anyone knew how to do it. Thanks, JK |
#3
|
|||
|
|||
Jon,
Thanks for the response. Basically I am trying to automate the output of lots of reports that will all have different fields and column widths. There needs to be many worksheets each with sevaral embedded worksheets. Basically, I want to group related reports on to the same worksheet but get the formatting looking right for each one, hence the thought about embedding several worksheets into one. Hope this makes sense. Is there another way to do it? JK. Jon Peltier wrote in message ... JK - You're embedding worksheets within worksheets? Why? Why not just insert the worksheets in line with the main worksheet? To open or edit the embedded worksheet, the parent Excel has to open another instance of Excel, and the chart on the outside of this other instance will never be able to access the data across this barrier. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ JK wrote: Hi, I have a worksheet with several embedded worksheets. I would like to create a chart based on the data of one of the embedded worksheets without putting the chart in the embedded worksheet. I have tried unsuccessfully to do this. I just wondered if anyone knew how to do it. Thanks, JK |
#4
|
|||
|
|||
Are you trying to make it output a series of reports the way Access
does? You could use Access, or you could keep the data on other sheets, then make copies of the data (hold Shift while Selecting Copy Picture from the Edit menu, use a combination of options that gives you Picture, not Bitmap), and paste them into your summary worksheet. Make a chart from the original data in the other worksheet, and embed it in the summary worksheet. An alternative to copying a picture of the worksheet is to use the camera tool (you'll have to add it to a command bar; use View Toolbars Customize Commands tab, select the Tools category, or All Commands if I've gotten it wrong, scroll down the list to Camera, and drag it to a convenient place), which copies an actively linked picture. The problem with embedding is that each embedded object contains a copy of the entire workbook, not just the pretty output area of the sheet. It gets huge quickly. And I've found that activating and deactivating an embedded Excel object will cause it to resize unpredictably. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ JK wrote: Jon, Thanks for the response. Basically I am trying to automate the output of lots of reports that will all have different fields and column widths. There needs to be many worksheets each with sevaral embedded worksheets. Basically, I want to group related reports on to the same worksheet but get the formatting looking right for each one, hence the thought about embedding several worksheets into one. Hope this makes sense. Is there another way to do it? JK. Jon Peltier wrote in message ... JK - You're embedding worksheets within worksheets? Why? Why not just insert the worksheets in line with the main worksheet? To open or edit the embedded worksheet, the parent Excel has to open another instance of Excel, and the chart on the outside of this other instance will never be able to access the data across this barrier. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ JK wrote: Hi, I have a worksheet with several embedded worksheets. I would like to create a chart based on the data of one of the embedded worksheets without putting the chart in the embedded worksheet. I have tried unsuccessfully to do this. I just wondered if anyone knew how to do it. Thanks, JK |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating a Unique Chart - New User - Please help!! | Seshmut | Charts and Charting | 3 | June 8th, 2004 12:39 AM |
Adjusting Chart source data when column is deleted | YBTM | Charts and Charting | 1 | January 29th, 2004 08:31 PM |
Chart Source Data Ranges Changing when Data Sheet updated from text file source. | Tekn0 | Charts and Charting | 3 | January 8th, 2004 04:45 PM |