Make Y-axis values correspond to x- axis value

T

Tonso

(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
 
C

claus_busch

Hi Tonso,

Am Mittwoch, 26. März 2014 22:10:44 UTC+1 schrieb Tonso:
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?

select your Chart => Chart Tools => Select Data => Horizontal Axis Labels => Edit and Change the Axis Label Range to your expected range.
You can look here:
https://onedrive.live.com/?cid=9378...#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for the workbook "Chart_T"

Regards
Claus
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top