Re: Columngraph

Hi,
Thank you very much for your help, it works perfectly, I
still have one question. I there a way to have always the
same "color"format for the graph : this means the first
column in the columngrahp always red, the second always
blue ... )
Thanks in advance !
Jeroen


>-----Original Message-----
>You can create a chart from all the data, then filter the
data to see
>individual results.
>
>1. Select all the data, and create a chart
> (it will be very crowded, but just ignore that)
>2. Locate the chart on a separate sheet, or place it
above the chart
>data. Or, select the chart, choose Format>Object, and set
its properties
>to 'Don't move or size with cells'
>3. Select a cell in the chart data
>4. Choose Data>Filter>AutoFilter
>5. From the dropdown list in the Name column, select a
name
>6. The chart will show only that individual's data.
>
>Note: This technique will work if the chart is set to
plot visible cells
>only (select the chart, choose Tools>Options, Chart)
>
>Jeroen wrote:
>> Hi,
>>
>> Can someone help me with the following thing.
>> I'll give an example :
>> I have a table with 200 rows en 5 columns
>> Each row is an individual. I want to place the values
of 1
>> individual in a columngraph. (This is very easy of
>> course..) I create a graphsheet for the first row. BUT
the
>> problem is that I have to represent each individual in
>> such a columngraph : this means 200 graphsheet (which I
>> find very silly )
>> So My question : is it possible to create something in
>> excel sothat I can represent on the same graphsheet
also
>> the values of the other 199 individuals. So I need
>> something in the graphsheet to select a individual (I
>> think the X-value) and than I see the graph of this
>> specific individual.
>>
>> I hope someone can help me with this problem.
>> Thanks in advance.
>> Jeroen
>
>
>--
>Debra Dalgleish
>Excel FAQ, Tips & Book List
>http://www.contextures.com/tiptech.html
>
>.
>

If you set the chart to show the data series by column, the colours
should remain the same for each individual:

1. Select the chart
2. On the chart toolbar, click the 'By Column' button
or
Choose Chart>Source Data, and on the Data Range tab, select
Series in: Columns

Jeroen wrote:
> Hi,
> Thank you very much for your help, it works perfectly, I
> still have one question. I there a way to have always the
> same "color"format for the graph : this means the first
> column in the columngrahp always red, the second always
> blue ... )
> Thanks in advance !
> Jeroen
>
>
>
>>-----Original Message-----
>>You can create a chart from all the data, then filter the
>
> data to see
>
>>individual results.
>>
>>1. Select all the data, and create a chart
>> (it will be very crowded, but just ignore that)
>>2. Locate the chart on a separate sheet, or place it
>
> above the chart
>
>>data. Or, select the chart, choose Format>Object, and set
>
> its properties
>
>>to 'Don't move or size with cells'
>>3. Select a cell in the chart data
>>4. Choose Data>Filter>AutoFilter
>>5. From the dropdown list in the Name column, select a
>
> name
>
>>6. The chart will show only that individual's data.
>>
>>Note: This technique will work if the chart is set to
>
> plot visible cells
>
>>only (select the chart, choose Tools>Options, Chart)
>>
>>Jeroen wrote:
>>
>>>Hi,
>>>
>>>Can someone help me with the following thing.
>>>I'll give an example :
>>>I have a table with 200 rows en 5 columns
>>>Each row is an individual. I want to place the values
>>
> of 1
>
>>>individual in a columngraph. (This is very easy of
>>>course..) I create a graphsheet for the first row. BUT
>>
> the
>
>>>problem is that I have to represent each individual in
>>>such a columngraph : this means 200 graphsheet (which I
>>>find very silly )
>>>So My question : is it possible to create something in
>>>excel sothat I can represent on the same graphsheet
>>
> also
>
>>>the values of the other 199 individuals. So I need
>>>something in the graphsheet to select a individual (I
>>>think the X-value) and than I see the graph of this
>>>specific individual.
>>>
>>>I hope someone can help me with this problem.
>>>Thanks in advance.
>>>Jeroen
>>
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>>.
>>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html