Start and finish values on X-axis

How do I enter my own start and finish values along the x-axis of a graph made in excel 2003 ?
Europa MacDonaldChief slayer of dragonsAsked:
Who is Participating?
 
byundtConnect With a Mentor Commented:
Change the chart type from "Line" to "Scatter".

A Line chart doesn't let you control the minimum and maximum values on the X-axis because they are really category labels.

A Scatter chart is the traditional X-Y (Cartesian) chart that you learned in high school. You can set the minimum and maximum values of the X-axis on a Scatter chart using the technique described by ssaqibh.
0
 
Saqib Husain, SyedEngineerCommented:
Right-click on the axis label
select format axis
from the axis options enter the minimum and maximum values desired.
0
 
Rob HensonFinance AnalystCommented:
By x-axis are you meaning the category labels along the bottom?

The x-axis labels are set in the source data screen.

Left hand side shows the Data Series and the right hand side shows the relevant detail for each series when selected.

Below the right hand pane, there is the range chooser for the x-axis labels.

Thanks
Rob H
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
Europa MacDonaldChief slayer of dragonsAuthor Commented:
If I select the scale tab

the options I have are

value (y) axis crosses at category number  (not suitable)
number of categories between tick mark labels (not suitable)
number of categories between tick marks (not suitable)

Do I have the correct dialogue ?
0
 
Rob HensonFinance AnalystCommented:
Can you expand on your question to explain what you are trying to achieve?

A sample file would be good but don't forget to replicate with dummy data.

Thanks
Rob
0
 
Europa MacDonaldChief slayer of dragonsAuthor Commented:
Is there a way that I can change the values of the category labels ?




A scatter diagram is not appropriate to my work
0
 
Rob HensonConnect With a Mentor Finance AnalystCommented:
As per my comment, the category labels are in a range found on the source data window.
0
 
byundtConnect With a Mentor Commented:
If you want more category labels displayed than you have data, make sure that the value cells for the extra category labels are blank.

If you want fewer category labels displayed than you have data, just adjust the beginning and ending points of the range being plotted.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.