5-16: Use Numbers on the X Axis of an Excel Chart
Using numbers on the X Axis of an Excel chart can cause problem. Problems can occur when you need to plot numbers (such as the year) along the horizontal axis. Excel wrongly assumes that the numbers are a series. In this lesson you’ll use such a worksheet to confuse Excel and then fix things up using the Select Data Source dialog.
As with all video lessons from The Smart Method®, there's a sample file download link at the beginning of the video to enable you to work along with the lesson.
This video comes from the "Charts and Graphics" session (Session 5 in our YouTube Excel Essential Skills free video training course).