Avatar of Europa MacDonald
Europa MacDonaldFlag for United Kingdom of Great Britain and Northern Ireland asked on

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 ?
Microsoft OfficeMicrosoft Excel

Avatar of undefined
Last Comment
byundt

8/22/2022 - Mon
Saqib Husain

Right-click on the axis label
select format axis
from the axis options enter the minimum and maximum values desired.
Rob Henson

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
ASKER
Europa MacDonald

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 ?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Rob Henson

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
ASKER CERTIFIED SOLUTION
byundt

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Europa MacDonald

Is there a way that I can change the values of the category labels ?




A scatter diagram is not appropriate to my work
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.