scatter charts

Hi,
one possibility is to plot each product as a separate series. This
results in a separate marker for each product and a legend showing each
product's name and marker.
If that's what you want you can select all three columns then start the
chart wizard. Select X-Y Scatter then Next. In Step 2 of 4 click on the
Series tab. Use the Remove button to remove both the Penetration and
AWOP series then click on the Add button. Set up this new series by
clicking on the little button with the red arrow on the right side of
the Name: box, then click on the cell with Brioche then back to the
little button with the red arrow. Now click on the little button with
the red arrow on the right side of the X Values: box, then click on the
worksheet cell containing Brioche's penetration value (7.5), then back
to that button. Now click on the little button with the red arrow on
the right side of the Y Value: box, then click on the worksheet cell
with Brioche's AWOP value (2.7), then back to the little button. That
does Brioche as a separate series, now do the same for every other
product, starting with the Add button to add the next series for
Croissants. After you've done all that you might want to reformat the
markers, Excel's choices are pretty poor.
Ken Johnson

I am running Excel 2000, any ideas if it can create it automatically in later version.

Thanks