Sorry for the late response. you were correct, I had been working with the
wrong chart type. Thanks to all for your help.
--
Dave B


"Mike Middleton" wrote:

Dave B -

In Excel 2007, if you have an XY (Scatter) chart type, the Edit Series
dialog box will contain "Series name",
"Series X values" and "Series Y values".

If you have some other chart type, e.g., a Line chart type, the Edit Series
dialog box will contain "Series name" and "Series values."

Your original post said you had an XY chart. Maybe you don't.

- Mike
http://www.MikeMiddleton.com



"Dave B" wrote in message
...
Herbert,
Still no go.
I underrstand the process you have provided and it is an elegant approach.
My problem seems to boil down to the "Edit Series" box from the "Select
Data"
window. In your example, your "Edit Series" box contains "Series Name",
"Series X Value" and "Series Y Value". The box I bring up contains only "
Series Name" and "Series Value". where am I going wrong?
--
Dave B


"Herbert Seidenberg" wrote:

Excel 2007 Chart
Dynamic min, max points.
No extra cells used.
http://c0718892.cdn.cloudfiles.racks.../04_16_10.xlsx
Pdf preview:
http://www.mediafire.com/file/mr2gzzynhig/04_16_10.pdf

.

.