Now the data points are evenly spaced, and line up with the dates shown on the horizontal axis. In that case, you can switch the type to text. However, there may be times where you want a simple, even distribution. The axis shows an accurate distribution of the data. Now it's clear that the stock price data is plotted across the date range, and the data points don't necessarily line up with the dates in the axis. It'll be easier to see what's happening if I add data labels and drop lines to the chart. This is a little strange and maybe even confusing. Notice since we have a large date range, the interval is set to 1 year, and all dates are January 1. You can see category in the name, and if I open the format task pane to axis options, you can see Excel is using the Automatic setting, which, since we have valid dates, means we have options for minimum and maximum dates, as well as date intervals. If plot this stock price data as a line chart, the horizontal axis is automatically set up as a category axis with a type of "date". When you create a chart using valid dates on a horizontal axis, Excel automatically sets the axis type to date.įor example, this stock price data is spaced out over a period of more than 10 years, in random intervals. In this video, we'll look at an example of how Excel plots dates on a horizontal axis.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |