• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

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 ?
0
Europa MacDonald
Asked:
Europa MacDonald
  • 3
  • 2
  • 2
  • +1
3 Solutions
 
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 HensonIT & Database AssistantCommented:
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
 
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Rob HensonIT & Database AssistantCommented:
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
 
byundtCommented:
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
 
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 HensonIT & Database AssistantCommented:
As per my comment, the category labels are in a range found on the source data window.
0
 
byundtCommented:
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

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now