Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel graphing
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel graphing
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel graphing
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/P...cle.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 ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ M B wrote: 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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel graphing
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. Jon Peltier wrote in message ... 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: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Graphing | Excel Discussion (Misc queries) | |||
Graphing in Excel | Excel Discussion (Misc queries) | |||
Graphing in EXCEL | New Users to Excel | |||
Graphing errors in excel | Charts and Charting in Excel | |||
MS EXCEL graphing | Excel Discussion (Misc queries) |