Thread: Excel graphing
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier[_4_] Jon Peltier[_4_] is offline
external usenet poster
 
Posts: 90
Default Excel graphing

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?