I guess I don't know what you mean by "a" meets "b".

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


Tony Houston wrote:

Thanks Jon not quite what i need as this shows both points.

I need to show a symbol of any kind where the two axis meet for each
segment, so some kind of symbol at cross point where "a" 2.6 meets "b" 2.0.
so only one marker shows at the meeting point.
Hope this clarifies. i would send a graphical representation but not sure
how to attach a file.
Tony

"Jon Peltier" wrote:


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