Chart series ?

gaftalik

Well-known Member
Joined
Feb 6, 2003
Messages
521
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

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

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
 
Upvote 0

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
 
Upvote 0

gaftalik

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

(y)
 
Upvote 0

Forum statistics

Threads
1,187,188
Messages
5,962,112
Members
438,585
Latest member
peterLEE0223

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