X Axis Data

R

RJ831JK

im trying to produce a line graph, with data showing
year and rainfall amounts, but when i create the graph its not showing the year in the x axis its just labels them 1,2,3 etc and not 1985, 1990 etc why is this
 
J

Jon Peltier

Make sure your data has year in one column and rainfall in the next.
Select both columns of data when you create an XY Scatter chart (not a
Line chart). Excel will use the first column for the X data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working with Dates and "Active Wells".... HELP! very confusing! 0
Plotting Graph with dynamic table 3
Make Y-axis values correspond to x- axis value 1
Use text descriptors as Y axis units 1
Getting the graph style I want 4
Gantt chart duration not showing 0
Template with fields and premade texts.. 0
Hide Graph of Data Outside X-Axis Range 2

Top