Scatter Plot Graph not showing correct result

**Peter Niklas** · 01-09-2021, 06:41 AM

Hello,

I have a problem with a scatter plot graph.

In the attached file I have created two graphs. I want the Sales on the Y axis and the EBITDAx on the X axis.

In the graph with the Swedish companies, it seems that there are a large amount of companies 100 - 400 in EBITDAx when looking at the scatter plot. But when I look closer at the data set only ca 10 companies have more than 50x. It seems that the graph is not portrayer what I want.

Can anyone help me here?

/Peter

**Andy Pope** · 01-09-2021, 07:26 AM

You data contains information that excel thinks is text. Once a scatter chart detects textual values the X values are ignored and a simple sequential index is used for the X points.

You need to clean the cells that appear to be blank.

Scatter Plot Graph not showing correct result

LinkBack

Thread Tools

Rate This Thread

Display

Scatter Plot Graph not showing correct result

Re: Scatter Plot Graph not showing correct result

Thread Information

Users Browsing this Thread

Similar Threads

Scatter Plot not showing all data points

Help with Scatter Plot graph

Custom Data Labels does not update with correct labels in a dynamic Scatter XY Plot Graph

XY scatter plot returns '1900' values instead of correct dates on x-bar

Labels on a XY scatter plot are no longer correct when using filters

XY scatter plot graph

[SOLVED] Scatter Plot graph

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions