Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Q. Can my Chart Area contain more than 1 pie chart ?

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,489
Default Q. Can my Chart Area contain more than 1 pie chart ?

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


--

Cheers
Andy

http://www.andypope.info

  #3   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
need variable time axis available in XY chart for area chart Byron Charts and Charting in Excel 0 February 6th 10 03:58 PM
need variable time axis available in XY chart for area chart Byron Charts and Charting in Excel 0 February 6th 10 03:17 PM
how to remove dotted line with words chart area from around chart desof Charts and Charting in Excel 2 May 13th 09 10:18 PM
Area Chart combined with Line Chart jmrd Charts and Charting in Excel 4 June 12th 07 07:01 PM
why is the chart displayed only when the chart area is clicked on? Vivien Charts and Charting in Excel 1 October 27th 06 04:29 PM


All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"