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.
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