Grafic specific Info.....

**carloslp** · 04-04-2005, 04:24 AM

I want to grafic only the data from the row that has a zero "0", in column "E", ex. In this case is row A3.

A------------B-------------C-------------------------E
DATE------TEMP---------PH-----------------------"0 O 1"
01/11/04----25----------7.8----------------------- 1
02/11/04----26----------7.5----------------------- 1
03/11/04----27----------7.2----------------------- 0
04/11/04----26----------8.2----------------------- 1
05/11/04----27----------7.3----------------------- 1

How can I graphic only the info I want, which is the data from comumn E marked as a 0.

Thanks for your time and help.

CVZ

**Domenic** · 04-04-2005, 09:24 AM

One way would be to use AutoFilter, and then create your graph from the filtered data.

Will this work for you?

**carloslp** · 04-04-2005, 09:59 AM

but how do i make the auto filter?

**Domenic** · 04-04-2005, 10:34 AM

Try the following...

1) Select your data, including your headers/labels, in your example select A1:E6

2) Data > Filter > AutoFilter

3) Click the drop-down arrows in Column E, and select 0

Then create your chart. Also, before you create your chart, you can hide any column that you don't want to include in your chart.

Hope this helps!