how do i change horizontal values on chart in excel

C

carl

I have a list of values its a load vs. deformation chart....i want the load
on the y-axis and deformation on the x....i have the chart made and
everything looks fine except the deformation is way off. my deformations are
..01 inch and its reading like 1000 on the axis for some reason. how do i fix
it to read the correct values. this new program is awful I wish it was like
the old excel because I knew how to do that
 
D

David Biddulph

Perhaps you used the wrong type of chart? Are you sure that you used an XY
chart? Things like line charts have category numbers, rather than using the
X values which you have specified.
 
S

Shane Devenshire

Hi,

If you have you data on a line chart I would expect it to show number like
1, 2, 3,... not 1000. Are you giving us all the details?
 

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

simple chart 0
Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend 0
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Labeling on independently stacked line chart 0
Plot value at top of chart 1
Average bar charts with individual data points 2
Excel 2007 - How can I switch the data on vertical and horizontal 1
Excel 2007 charts: want to avoid zero values 1

Top