Tony -

I'm not certain, but I think you want a scatter chart. Select the range
of "a" and "b" data and start the chart wizard. On the first tab choose
an XY Scatter chart. This gives you a chart with markers for each point
defined by X in tha "a" column and Y in the "b" column.

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


Tony Houston wrote:
I have the table below as the result of other sheets.
a b average formula
seg 1 3.7 3.5 3.6 3
seg 2 2.1 3.0 2.6 2
seg 3 2.6 2.0 2.3 2
seg 4 4.6 3.0 3.8 3
seg 5 3.0 4.0 3.5 3
seg 6 2.3 4.0 3.2 2

the formula column just shows the result of a simple IF formula
I want to show on a chart that reflect the number in the formula column and
shows a symbol where the two axis meet

i.e seg 3 shows a star where "a" 2.6 meets "b" 2.0.

Can any one help please. Thanks Tony