View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kieran[_18_] Kieran[_18_] is offline
external usenet poster
 
Posts: 1
Default Q. Pie Chart problem. Want to add series, from another worksheet.

Jim,

From what you describe I imagine that you have 3 cells currently that
you are plotting.
In a fourht adjacent cell enter = then navigate to the value in the
otehr workbook that ou wnat to display, and then press enter.
You will now see the addtional value shown in the 'main' workbook.
It should then be a simple matter to adjust the graphs range scope to
incorporate the new value.

Hope it helps


---
Message posted from http://www.ExcelForum.com/