Plotting results of survey fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that measures various aspects of particular features
(i.e. usability, age of application, etc) as noted in the chart sample below

Ease of
Feature Use Flexibility
A 1 4
B 2 2
C 3 5
D 5 5
E 1 1

I want to compare my results in a matrix that allows those features ranking
low (1,1) to be plotted on the lower left of the chart and those ranking high
(5,5) in the upper right, with values in between. I have tried to do this as
a scatter diagram, but am having difficulty getting the results to plot
correctly.

Also, I need to separate those entries having the same results so they do
not lay on top of each other. Any assistance you can offer is appreciated
 
Select the numbers (and just the numbers) in the 'Ease of use' and
'Flexibility' columns. Create a XY Scatter chart. The first should be
on the x-axis, the 2nd on the y-axis.

Download and install either XY Chartlabeler (www.appspro.com) or Chart
Tools (www.j-walk.com). Use it to add column 'Feature' as the
datalabels.

If this is a one time (or infrequent) graph, manually move any
overlapping labels to aesthetically appealing alternative locations.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top