Graph with dates on X axis

ads464

New Member
Joined
Feb 15, 2017
Messages
1
Hello all,
Trying to create a graph and I want just the dates on the bottom axis. But i have a different number of data points per month and the graph keeps bunching all data up.

I just want to know how to do a simple line graph please like below.

Numbers
l
l
l____________________________
aug sept oct nov dec jan feb etc etc

2015 2016


This is the data:

2015Aug10
Aug15
Sep22
Sep26
Sep30
Sep35
Oct40
Nov90
Nov60
Nov66
Dec80
Dec120
Dec150
2016Jan140
Jan145
Jan150
Jan179
Jan186
Jan200
Jan205
Jan215
Feb220
Feb225
Feb231
Feb250
Feb270
Feb280
Mar270
Mar282
Mar320
Mar334
Apr340
Apr337
Apr345
Apr365
Apr380
May390
May400
May405
Jun420
Jun430
Jun435
Jun440
Jul460
Jul470
Jul474
Aug478
Aug480
Aug488
Aug495
Aug515
Aug520
Aug530
Aug535
Aug540
Aug535
Aug540
Aug550
Aug557
Aug565
Aug575
Sep585
Sep600
Sep610
Sep615
Sep650
Sep680
Sep700

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>


Thank you so much in advance!

Ads464
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
If you have the actual dates (month-day-year) as opposed to just the year and month that you've shown, put these dates into a single column, and your values in the next column, and make a line chart.
 
Upvote 0

Forum statistics

Threads
1,214,601
Messages
6,120,462
Members
448,965
Latest member
grijken

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
Back
Top