Scatter Graph and Time Scale

Scatter Graph and Time Scale

Scatter Graph and Time Scale

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. In most cases the last tick mark will not place at the end of the axis too.

Besides the traditional way, we could also use scatter chart to create a line graph, in order to make the timescale absolute accurate. Lets begin!

* 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 any 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, simple as that

* 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

POST COMMENT

Secret Trading Strategy See How I Turned $1000 Into $1m+ In 13 Months Trading Penny Stock - Anabolic Cooking Pdf-Anabolic Cooking will tell you how to cook and how to eat Experience Activities And Adventures On Dartmoor National Park Photoshop Is The Best Tool Ever Used For Editing And Producing Iamges Historic North Wales: Castles and Castellated Mansions of Snowdonia About Alupka Crimea and Voronzov's Palace Chefwear And Uniforms- Serving Up A Treat The Good, The Bad And The Orange! How To Snap Out Of A Bad Mind Set And Get Back On Track Fact: 95% Never Make A Dime And What You Can Do About It The Top 5 Mp3 Cd Players And How They Differ From The Average Mpc Cd Player Less Pricey Yet Exciting And Funfilled Break Only With Sin City Us All-inclusive Packages Birth Announcements And Ways To Plan For Them