![]() Right-click on the X-Axis change the Axis type to Date axis to be sure excel sees the X-values as dates. ![]() If you try the same in the business charts you'll see that option.įor ex., instead of a Scatter Chart for your values use a Line Chart. ![]() The scatter chart is the one you'll use if you are using excel for other purposes like physics or mathematics and in that case it makes all the sense that the x-axis ticks are, by default, equidistant. ![]() Thanks for the feedback.Īs for the possiblity (or not) of having the month as the unit for the the X-Axis, I'd say that MS probably does not see the scatter chart just as a business chart. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |