An alternative is to set up your series in additional columns to the right
of the Y values column, and use clever IF statements to place either the
value or NA() in these additional columns. Each of these becomes a series in
the chart, each with its own formatting.

Here's an illustrated tutorial:
http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"BDB" wrote in message
...
Thanks Driller.

The file I'm using has almost 13000 entries. I'd like to keep all the
data
together for other analysis rather than rearrange it. I was hoping there
was
an easy way to do this that I could turn on and off with out moving around
the values. Perhaps not. Thanks for the thoughts.

"driller" wrote:

BDB,

since your desire a Chart to FIND the trend of points via *either symbol
shape or symbol color*, it may be easier if you re-group the series of
points
BASED on their respective classified zone and excel can help to provide
you
with auto-symbol that represent each zone.

--
regards,

"BDB" wrote:

Is there a way to choose either a symbol or color for points in a plot
according to a value in a field?

Here is what I'm trying to do:
I'm plotting depth vs porosity for some rock samples. In the file I'm
using
I also have a 'zone' associated with each sample. I'd like to use that
zone
column to determine either symbol shape or symbol color so I can see
trends
for individual zones in the bigger plot.

Can this be done?

Thanks for the help