View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Tonso Tonso is offline
external usenet poster
 
Posts: 90
Default Make Y-axis values correspond to x- axis value

(x) (y)
Group Minutes
-2 1.79
-1 7.61
0 26.45
1 28.9
2 17.18
3 27.8
4 26.1
5 26.7
6 25.8
7 21.8
8 17.4
9 0
10 33.69
11 0
12 0
13 0
14 14.8
15 0
16 0
17 17.18
18 0
19 0
20 20.48
I want to make a column graph(or bar), with the "Group" numbers being on the x-axis, and the "Minutes" being the y-axis value, so that "-2" is an x-axis value, and the above it is the bar representing 1.79, then the next value on the x-axis will be "-1", and above it will be a bar representing 7.61, and so on. It seems simple enough, but i am unable to accomplish this. What must I do?

Thanks,

Tonso