create chart with significant data in a column

[jdarmstr]

I would like to create a chart in excel with data in a column but only want
the significant data used. For example, I have two columns - one with names
and the other with values ranging from 0 to 10 (the cell is blank). The
colums are long. I want a chart from these columns that only uses the cells
that have values in larger than 5. Is there a way to do this without me
going through the data and only selecting the appropriate cells?

An even better solution would be to reference a different cell for the
minimum value to use.

thanks

 

[Jon Peltier]

Select your data, go to the Data menu, select Filter, then select Autofilter. In
the new dropdown above the column you want to filter, choose Custom, and in the left
box choose Greater than, and in the right box enter 5.

The autofilter hides the rows that are not greater than 5, and by default the chart
will only display values from visible cells.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______