Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Use an xy-scatter chart type rather than Line.
Excel line charts - using a numeric x-axis
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I want to chart data over a range of temperatures. The temperature range is -40 to +125. My data is at -40, 0 25, 85 and 125. When I use a line chart, I get five equally spaced CATEGORY labels. This makes my data look wonky. How can I produce a line chart where the x-axis accurately shows the spacing between the data points?
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
2 answers
Sort by: Most helpful
-
Anonymous
2017-05-09T13:53:31+00:00 -
Anonymous
2017-05-12T13:37:14+00:00 Hi,
Just to confirm, have you already tried the suggestion of Andy Pope above? How did it go? Let us know if you're still experiencing this issue so we can recommend other troubleshooting steps that you can perform.
We'll wait for your response.