Creating a chart based on the data in an embedded worksheet

  • Thread starter Thread starter JK
  • Start date Start date
J

JK

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
 
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/
_______
 
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.
 
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
Click to expand...
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/
_______
 
Back
Top