This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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)
How do I make a line graph with inequalities and data ranges? Whenever I make the graph, the numbers on the x and y axis do not correspond to the data in the chart. X values: 8,18,41,52,20,11. Y values: ≤50, 51-60, 61-70, 71-80, 81-90, ≥90
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
Maybe I don't understand what the problem is. Please post a sample file on your OneDrive Public folder and share it. Post the link here. Then explain what data you want to see in the chart.
So what you're saying is excel cannot detect inequalities?
Hello,
a line chart plots the x axis as categories, not numbers. If you need to position the X value precisely, you need to use an XY Scatter chart. It can be formatted to show with lines or without lines, with markers, or without markers.
It looks like your data has numbers for the X axis, but the Y axis has text that describes a number range. Try to convert that to real numbers, so the data can be plotted. Excel cannot plot text values on the Y (value) axis.