It tells you how under Charting in Excel help.
Copy the data from the data sheet, then when you click on the chart you'll
find Paste Special under Paste in the Clipboard group on the Home tab.

I'm still trying to find my own way around Excel 2007, & particularly the
charting functions.
--
David Biddulph


"Dave B" wrote in message
...
The formulas work, but the cut and paste doesn't. (from the earlier link,
starting in step 4.) There is no "paste special" process and just cutting
and
pasting does not link the min and max data to the main data set.
--
Dave B


"David Biddulph" wrote:

Yes, in general that looks like the way I would expect it to be done.
Which
part are you struggling with in 2007? If it is the general problem of
translating 2003 menu instructions to corresponding 2007 commands, try:

Some hints on 2003 to 2007 command mapping:
http://office.microsoft.com/en-us/ex...491511033.aspx
http://www.rondebruin.nl/0307commands.htm
http://www.computerworld.com/action/...leId=9028 218

If there is some specific stage, tell us which.
--
David Biddulph


"Dave B" wrote in message
...
See "http://processtrends.com/pg_charts_min_max.htm"

--
Dave B


"David Biddulph" wrote:

Tell us how you did it in 2003, the hopefully we'll be able to tell
you
how
to do it in 2007.
I would have expected that on your data sheet you would have formulae
to
give the min and max, and then you'd use those as new series to add to
your
chart.
--
David Biddulph


"Dave B" wrote in message
...
I want to just label and highlight the min and max values in an XY
chart
and
have them move appropriately if the data change. i saw a tutorial on
line
about doing so in 2003 but I can't get it to work in 2007.
--
Dave B


.


.