View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Nikhil Nikhil is offline
external usenet poster
 
Posts: 44
Default Plotting data points on 2 axis

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