Chart series ?

[gaftalik]

Hi,

I have 2 columns one showing clients and other hours and as follows:

0 3
1 0
8 3
9 14
10 32
11 55
12 82
13 105
14 118
15 128
16 130
17 136
18 147
19 149
20 130
21 94
22 57
23 24
after selecting both columns the chart "Line" showed me the hrs as points 1 to 18 but i need to show me instead of ascending order of 18 pts to show me exactly the hrs from 0 to 23 to see the highest nbr of clients falling at the specific hour (in this example = hr 19 )

Thank you

 

[SIXTH SENSE]

hi!
Try using scattered plot where your first column will be the X axis and the second column be the Y axis

 

[jimbojones]

Can you not right click the x axes of the chart and use the scale page of the dialog box to put in your units (i.e. 1) and your maximum???


Jim

 

[gaftalik]

It really worked with the scattered type, thank you all !