ExcelBanter - Table Data on Chart.

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Table Data on Chart. (https://www.excelbanter.com/excel-programming/293628-table-data-chart.html)

BSena

Table Data on Chart.

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

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.

All times are GMT +1. The time now is 12:42 PM.