Re: How to combine two sheets in order to display the data on Pivot Chart?

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 03/13/04 

Date: Sat, 13 Mar 2004 10:06:48 +0100

Hi Bill
still not sure about your layout. If you like email me your spread***
and I'll take a look at it:
frank[dot]kabel[at]freenet[dot]de 

--
Regards
Frank Kabel
Frankfurt, Germany
BSena wrote:
> Hi,
>
> Could someone plz look this matter as I asked?
>
> Thanks
>
> Bill
>
> bill_sena@hotmail.com (BSena) wrote in message
> news:<2ceca914.0403112220.6cbbdd9c@posting.google.com>...
>> Thanks Frank,
>>
>> On both the sheets, the nature of data is character.
>> The data comes from the table and displayed on both the sheets.
>>
>> With regards to *** 1, the data is constant (same value will be
>> dispalyed).
>> There is only single value in a cell in *** 1.
>>
>> On the other sides, there are several rows which comes from the
>>  table, on *** 2, which uses the rows of Cell A and Cell B.
>>
>> With regards to *** 2, the number of rows may change.
>>
>> Any ideas from your side will be highly appreciated.
>>
>> Thanks
>>
>> Bill
>>
>>
>>
>>
>> "Frank Kabel" <frank.kabel@freenet.de> wrote in message
>> news:<OfvPdWzBEHA.1604@TK2MSFTNGP11.phx.gbl>...
>>> Hi
>>> you may explain what kind of data you have on both sheets
>>> - is the number of rows changing
>>> - do they have the same strucutre
>>>
>>> e.g. a macro copying both sheets into one could help
>>>
>>>
>>> --
>>> Regards
>>> Frank Kabel
>>> Frankfurt, Germany
>>>
>>> BSena wrote:
>>>> Dear Frank,
>>>>
>>>> Thanks
>>>>
>>>> Could you please suggest that how to combine two sheets in order
to
>>>> display the data from these two sheets on pivot Graph?
>>>>
>>>>
>>>> Thanks
>>>>
>>>> Regards
>>>>
>>>> Bill
>>>>
>>>>
>>>>
>>>> "Frank Kabel" <frank.kabel@freenet.de> wrote in message
>>>> news:<#qGIevqBEHA.3132@TK2MSFTNGP11.phx.gbl>...
>>>>> Hi
>>>>> you only can have one range for a pivot table. So As far as i
know
>>>>> (AFAIK) no chance to use two separate sheets as datasource for
ONE
>>>>> pivot table. combine the sheets prior to using pivot tables
>>>>>
>>>>> --
>>>>> Regards
>>>>> Frank Kabel
>>>>> Frankfurt, Germany
>>>>>
>>>>> BSena wrote:
>>>>>> Hi Frank,
>>>>>>
>>>>>> Could you please clarify your point?
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>> Bill
>>>>>>
>>>>>>
>>>>>>
>>>>>> "Frank Kabel" <frank.kabel@freenet.de> wrote in message
>>>>>> news:<OhSIeG0AEHA.688@tk2msftngp13.phx.gbl>...
>>>>>>> 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.
Loading