Put sales in column A and Margin in column B. Select the data, start
the chart wizard (the cute button, or Chart from the Insert menu), and
make an XY Scatter chart (not a Line chart).
- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______
MB wrote:
I would like to do Quadrant Analysis using Excel 2000. Very basically,
I would need to plot Sales $ on the X-Axis and Margin % on the Y-Axis
for a given list of items. Is this possible with Excel 2000?