However, Excel’s best guess might not be as useful as you need it to be. When you select a date or time range, and the data associated with it, Excel will take its best guess at organizing the information in the chart with the time-scale on the x-axis. Scatter charts automatically take date or time data and turn it into a time-scale axis. Images were taken using Excel 2013 on the Windows 7 OS.īy far, the easiest way to chart time data is to use a scatter chart. These features apply to Excel 2007-2013, though the specific steps will vary based on your version. Here are some tips for editing time and date data in an Excel chart. When you have data that involves time information, you may need some special tricks to get Excel to help you create useful charts. By Tepring Crocker Categories: Basic Excel Tags: Excel Time Chart
0 kommentar(er)
