1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Why are the Y Axis Values not being plotted Correctly?

Our take

If your line chart isn’t plotting correctly, particularly with the Y-axis values, there are a few key areas to investigate. Ensure that the data range selected for the chart includes all relevant values. Check if the scale of the Y-axis is appropriately set to reflect the data points. Additionally, verify that there are no discrepancies in data formatting that could affect plotting accuracy. By addressing these factors, you can align your chart's values and achieve a clearer visual representation of your data.

I currently have a line chart that is not plotting correctly.

I would like the value of 34.5 to match the value shown on the Y Axis, currently they are not aligned. What am I missing here?

https://preview.redd.it/1mf9dnunafrg1.png?width=1781&format=png&auto=webp&s=0ae3e2f8c4048175fa13c3ab435ec72aedbb2259

submitted by /u/Engineer0117
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

#rows.com#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#line chart#Y Axis#plotting#value#alignment#data visualization#Excel#graph analysis#coordinates#scatter#numerical values#chart configuration#data representation#axis scaling#charting error#visual discrepancy