View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Plotting data points on 2 axis

Make an XY chart using the data in columns B and C (parameters A and B).
Format each axis scale so the other axis crosses at 60%. Not the axes cross
in the middle of the chart. Format the patterns of each axis so its labels
are in the "low" location, not Next to Axis, to move them out of the way.
You can label the points with the store names using one of these free Excel
utilities:

Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Nikhil" wrote in message
...
I have a table in excel

Col A: name of stores
Col B: % scores on Parameter A
Col C: % scores on Parameter B

I want to plot a chart with Parameter A on X-axis, Parameter B on Y-axis.
The stores should be plotted as data points in all 4 quadrants.

While the scores for Parameter A & B are in % (0 to 100), i want the base
point as 60%. There would thus be stores (data points) in all four
quadrants
of the chart.

How can i plot such a chart. Plz help.

Regards

Nikhil