View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim Jones Jim Jones is offline
external usenet poster
 
Posts: 6
Default Q. Can my Chart Area contain more than 1 pie chart ?

Andy,

Most impressive.
I'm sure I'll learn something, once I've downloaded and studied your
examples. But I may still have some questions, after trying some
things.

One is this: What sort of PDA device on the market these days is
capable of displaying such charts, and recording data on the go ?

Thanks,
Jim

On Mon, 26 Jan 2004 16:52:57 +0000, Andy Pope
wrote:

Hi Jim,

You can have multiple chart objects on a chartsheet.
Create your two pies on a worksheet.
Now create a blank chart sheet by selecting a empty cell and press F11.
Go back to the worksheet and select a chart. Right click and selection
Location. Choose the object on ChartSheet. Repeat for other pie.

Or maybe you could try the pie by pie example from my page,
(http://www.andypope.info/charts/pies.htm)

Jim Jones wrote:

Hi,

I'd like to place a second pie chart in the chart area, which already
contains one pie chart. The data in the second one will not be related
to the first.

Do I have to settle for making a new chart area, or do I have to use a
separate worksheet altogether?

Thanks,
Jim