monkeylkp.blogg.se - Excel graph axis label start at 0

Perhaps you can put a sampling of your data into this spreadsheet to illustrate your question. I cannot create a similar effect on the line chart because a line chart cannot work divisions smaller than 1 day. I have specifically formatted the x axis of the scatter chart so that the major division axis labels will show different times of day. I don't know if it will help, but this is a copy of a spreadsheet with random data that I created to illustrate for someone else the diifference between scatter and line and how they treat date/time serials.

The graph of f(x) passes through (0,100) points (2,49) So option (a) is correct.

Therefore the equation of the y-axis is x 0 and its graph on the x and y graph chart is shown below. Then perform the date/time arithmetic using Excel's serial numbers. First create a graph which will function as a 'canvas' for the plots. Here is Excel 2010's list of date/time functions: Perhaps you could go back to the point before "adding" the time to the date and use the datevalue and timevalue functions to convert them to serial numbers. When creating a line graph using time (hh:mm:ss), Excel will automatically supply the values for the vertical (Y) axis based on the minimum and maximum time. This is the only chart type that supports a time scale on the x-axis. When done, you should have two rows of ticklabels, milli-seconds in units of 5 over 'centred' minutes. I might suggest a review of this ( ) to review how Excel wants to handle date/time data. In X-Axis options select 'Multi-level Category Labels' and go from there.

What format is your date/time data? Are they text strings? Date/time serials? Other? This is where not having an example of your data will make it really difficult to debug your solution.