Menu
How to make excel accept the following as different data points on the x-axis.
Time Licenses Used
2013-07-09 11:34 512
2013-07-09 11:36 523
2013-07-09 11:40 621
2013-07-09 11:43 125
2013-07-10 09:30 526
2013-07-10 10:30 589
2013-07-10 11:30 546
2013-07-11 10:40 549
Why does Excel charts club all the times on a date together, why cant it interpret it a different time entries?
222
In the Format Axis pane, select the Axis Options tab. Expand Axis Options, and then under Axis Type, make sure Date axis is selected. Under Units, next to Base, select Days, Months, or Years.
Excel provides options to display dates on the axis that can fix this blank space. Do right-click on the Y-axis and select Format Axis. In the Format Axis menu find Axis Type and switch it to the Text axis value. Dates in the chart have no blank space, now.
Right-click the X-axis in the chart you want to change. That will allow you to edit the X-axis specifically. Then, click on Select Data. Select Edit right below the Horizontal Axis Labels tab.
if you are using a line chart, change to an XY scatter chart with lines instead; a date axis on a line chart will ignore the time portion
67
There is one way to do this. To make the x-axis consider the values as text.
in Excel 2007, click on the chart - Go to the layout menu (contextual menu on clicking on the chart) , choose the option Axes->Primary Horizontal Axes-> More Horizontal Axes Options
Under Axis Type, choose "Text Axis"
42
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
