Adjusting time scale on x-axis in standard line chart could be a headache. It is kind of a trial and error process to make the time scale fit in, distribute the labels properly and last date being shown correctly at the end of x-axis.
Besides the traditional way, we could also use scatter chart to create a line graph, in order to make the timescale absolute accurate.
• Use data to create a XY (Scatter) chart in PowerPoint and select the lower right chart options to
make it a line only graph without markers
• When the chart is created we need the “General” codes of start and end date for use with some
simple calculations. Simply right click on start date on datasheet, press “Number” (or Ctrl 1) then go
to “General” tab to get the code. Repeat the process until you have both codes extracted
• Now depends on how many labels of date (x) you want to show on x-axis. Use the value obtained
from first date minus last date, and then divides the value using x. In this tutorial which is
40178 - 38383 ÷ 6 = 299.1667, as we want 6 labels being shown on timescale
• Go to format x-axis and select “Scale”, insert first date general code (38383) to Minimum, last date
general code (40178) to Maximum, and the quotient to Major Unit (299.1667)
As you can see now the time scale fits perfectly.
- End of Tutorial