Excel graphing

[MB]

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?

 

[Jon Peltier]

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

 

[M B]

Thanks John, however, the chart output does not yield the desired
effect.

I can not get my range of data to appear as (column a, column b)
coordinate points, i.e., (sales, margin). I have to plot them one at a
time using series selecting each x and y point. It does not plot them
(x,y) when I select a range.

Also, is it possible to show the data points with the item name as a
data label rather than the value?


Thanks...





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Jon Peltier]

Question 1. Are you sure you're making a SCATTER chart? It's the fifth
option in the Chart Type panel of the Chart Wizard. Line charts are the
third option, and they are NOT what you want. Read this article for
more information:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=190

Question 2. There are a couple of free addins that use worksheet cells
for data labels, instead of just the X or Y labels.

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon

 

[MB]

Again, thanks...

The Scatter Plot graph is now working and so is the XY Chart Labeler
add-in you recommended.

My last question, for now, is how can I draw horizontal and vertical
lines through the median of my graph data to reflect the quadrants?


Thanks again.