This question was submitted by Frank. He wants to know:

How do we control the x-axis and get the line chart to use the ages 62 to 100-ish on the x-axis?
The graph takes our range of 62 – 100 and turns the x-axis into 0 to 100?



Sometimes we can follow the chart wizard in Excel and everything will fall into place. However, here is an instance where a section of the graph is nonsensical to even show. So, we have to explicitly tell the graph what to use. Here is the answer via screencast:

Frank, thanks for submitting this question.  Does this give you what you needed to know?

If anyone else has anything to add, please jump in. You can also submit your own questions by using the contact form.

photo credit: cotallo-nonocot via photo pin cc