Chart series ?

gaftalik

Well-known Member
Joined
Feb 6, 2003
Messages
518
Office Version
  1. 2016
Platform
  1. Windows
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
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

SIXTH SENSE

Well-known Member
Joined
Oct 29, 2003
Messages
1,883
hi!
Try using scattered plot where your first column will be the X axis and the second column be the Y axis
 

jimbojones

Well-known Member
Joined
Apr 22, 2002
Messages
776
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

Well-known Member
Joined
Feb 6, 2003
Messages
518
Office Version
  1. 2016
Platform
  1. Windows
It really worked with the scattered type, thank you all !

(y)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,323
Messages
5,769,454
Members
425,549
Latest member
Bartekelese

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top