It works for XY charts. That's what I use it for frequently. Did you try it?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"balhal" wrote in message
...

I tried the solution and it's fine for data easily converted to a line
graph. I don't see how it can work with variable x data you often use for
a
scatter plot. For the simple graph described, you can use a line graph and
it
will be okay. But what if the original X data was something like 1, 1.2,
1.8,
4, 4.1 that you would like to see on a linear scale for the first graph.

Of course an obvious solution is to just use a set of text boxes, klugy
but
workable I suppose.

Did I miss something I can do to use the suggested approach for a scatter
plot?