Solved

Start and finish values on X-axis

Posted on 2013-11-19
8
186 Views
Last Modified: 2013-11-20
How do I enter my own start and finish values along the x-axis of a graph made in excel 2003 ?
0
Comment
Question by:MichaelGlancy
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39659683
Right-click on the axis label
select format axis
from the axis options enter the minimum and maximum values desired.
0
 
LVL 33

Expert Comment

by:Rob Henson
ID: 39659719
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
 

Author Comment

by:MichaelGlancy
ID: 39659723
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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 33

Expert Comment

by:Rob Henson
ID: 39659737
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
 
LVL 81

Accepted Solution

by:
byundt earned 334 total points
ID: 39659866
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
 

Author Comment

by:MichaelGlancy
ID: 39661110
Is there a way that I can change the values of the category labels ?




A scatter diagram is not appropriate to my work
0
 
LVL 33

Assisted Solution

by:Rob Henson
Rob Henson earned 166 total points
ID: 39661634
As per my comment, the category labels are in a range found on the source data window.
0
 
LVL 81

Assisted Solution

by:byundt
byundt earned 334 total points
ID: 39661700
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question