View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Jones Jim Jones is offline
external usenet poster
 
Posts: 6
Default Q. Pie Chart problem. Want to add series, from another worksheet.

OK,

You two allude to the idea that the series must all be on the same
worksheet for the pie chart to work as it does now - but with an extra
series (or value) that I wish to enter as a new 'slice'.

If that's the way it has to be I'm satisfied with the solution.
I just thought there would be a more keen way to incorporate it from
the separate worksheet - but this poses no problem. It will work.

Thanks for your help,

Jim
On Sun, 04 Jan 2004 23:29:46 -0500, Debra Dalgleish
wrote:

On the sheet with the first three amounts, add a link to the Expenses
amount on the other worksheet.

Then, create the chart from the four amounts on the first sheet.

Jim Jones wrote:
I have a pie chart with 3 slices.

One is Total Wins, The other Total Losses, the other is Total Outlay.

I want to add a fourth called Expenses, which is a calculated field
on a different worksheet, in the same workbook.

How can I add that 4th slice in there ?