?
Solved

Start and finish values on X-axis

Posted on 2013-11-19
8
Medium Priority
?
190 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:Europa MacDonald
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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:Europa MacDonald
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
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
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 1336 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:Europa MacDonald
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 664 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 1336 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

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!

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

765 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