Thread: Scatter chart
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Louise Louise is offline
external usenet poster
 
Posts: 217
Default Scatter chart

Hi all
I have created a basic worksheet, as shown below, and am trying to create a
scatter chart from the results. The problem I have is that I want each Point
on the chart to show the corresponding letter in Column A, however, if I
include Column A in the range, this is obviously shown on th chart as well,
which is incorrect.

A B C

a 1 2
b 2 4
c 3 2
d 4 3
e 5 7
f 6 1
g 7 9
h 8 4
I 9 5
j 10 6
k 11 3
l 12 10
m 13 8
n 14 9


Any idea how I can do this? (I do have a worksheet containing the basic
data and chart so far if anybody is willing to take a look?)

Thank you.

Louise