Microsoft Office Tutorials and References
In Depth Information
Converting Text Dates to Dates
Figure 3.12
Choose a date format
from the Number
dropdown on the Home tab.
After converting the text dates to real dates, insert a line chart with markers. Excel
automatically formats the chart with a date-based axis. In Figure 3.13, the top chart reflects cells
that contain text dates. The bottom chart uses cells in which the text dates have been
converted to numeric dates.
3
Figure 3.13
When your original data
contains real dates, Excel
automatically chooses a
more accurate date-based
axis. The bottom chart
reflects a date-based axis.
To watch a video of converting text dates to dates, search for “MrExcel Charts 3”
at YouTube.
Search JabSto ::




Custom Search