Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
need variable time axis available in XY chart for area chart | Charts and Charting in Excel | |||
need variable time axis available in XY chart for area chart | Charts and Charting in Excel | |||
how to remove dotted line with words chart area from around chart | Charts and Charting in Excel | |||
Area Chart combined with Line Chart | Charts and Charting in Excel | |||
why is the chart displayed only when the chart area is clicked on? | Charts and Charting in Excel |