Thread: Table Data on Chart.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default Table Data on Chart.
Hi
AFAIK you'll need a contiguous area for pivot tables/charts

--
Regards
Frank Kabel
Frankfurt, Germany

BSena wrote:
Hi

How should we make the pivot chart on EXCEL, which contains the
(char)data from two different work sheets?
The data from the table are on two work sheets.
Is there a way to select the cells from two different excel work
sheets and then make a single Chart?


Bill.
Reply With QuoteReply With Quote