excel/graph, sheet data shown in graph at wrong place according to the y-axe 10000 points to high

Question

I have very simple sheet where I want to make graph. The graph looks ok except that some data in the sheet are drawn 10'000 points higher relative to the y-axe!

The range is from 100 to 10'000. Changing the y-axe (log / linear) doesn't make any difference; the values stay aprox. at 10'000!

what do I do wrong? thanks for your time

Answer 1

It sounds like you may be encountering an issue with how Excel is interpreting your data for the graph. Here are a few steps you can take to troubleshoot and resolve the issue:

1. Check Data Range: Ensure that the data range you are using for your graph is correct. Sometimes, if the data range includes empty cells or incorrect values, it can affect the graph's output.
2. Verify Data Types: Make sure that the data in your sheet is formatted correctly. If your numbers are stored as text, Excel may not plot them accurately. You can convert text to numbers by selecting the cells, clicking on the warning icon that appears, and choosing "Convert to Number."
3. Adjust Y-Axis Settings: Since you mentioned that changing the Y-axis to log or linear doesn't help, double-check the minimum and maximum values set for the Y-axis. You might want to set the minimum value to 0 or a value that is appropriate for your data range.
4. Inspect Trendline: If you are using a trendline, ensure that it is set up correctly. An incorrect trendline can also skew how data points are represented in relation to the Y-axis.
5. Recreate the Graph: If the issue persists, try recreating the graph from scratch. Sometimes, starting fresh can resolve hidden issues with the graph settings.

If these steps do not resolve the issue, you may want to consult additional resources or forums for more specific troubleshooting related to your version of Excel.

---

References:

• Chart trendline formula is inaccurate in Excel
• How to use defined names to automatically update a chart range in Excel

Answer 2

I'm out of ideas ...

... I checked all of above points BUT cannot see an issues

However, i'm pretty sure it 's something on my side ... ?