Table Data on Chart.

[BSena]

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.

 

[Frank Kabel]

Hi
AFAIK you'll need a contiguous area for pivot tables/charts