Neither XY scatter or Line seem to help

nzqrcho

New Member
Joined
Feb 15, 2005
Messages
2
I am trying to plot 5 different lines on one graph. Each line is consists of about 500 points. Each point is a temperature value and a resistance value. The X axis is temperature and the Y axis is resistance. Every time I make an XY scatter plot, the range on the x axis is from 0 to 180 even though the data only goes from 77 to 120. If I do a line graph, then the x axis is nicely chosen to be about 77 to 120 but is completely non-uniform. The spacing is completely erratic. I need to have a correct range so I can see the plot and I need even spacing. Why is this so hard?
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Right-click the x-axis. Chose Format Axis... from thec popup menu then click the Scale tab.
 
Upvote 0

Forum statistics

Threads
1,214,621
Messages
6,120,563
Members
448,972
Latest member
Shantanu2024

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top