Go to the Insert tab in the Ribbon and click on the Scatter Chart icon to see the available chart types. So it's not an issue with my data being malformed. Including data labels in your selection will be automatically recognized by Excel. My guess is that it's because Power BI is treating my x-axis data as categories, which would also explain the spacing behavior.Īny idea why this is happening, and how to get the scatterplot to behave like Excel?ĮDIT: A scatterplot in R (drag in the data values from the PowerBI query, use "plot(dataset)") also works correctly. But adding color or shape, although possible, is very inconvenient and error-prone. It is even not too hard to add size (by changing chart type from X Y (scatter) to Bubble chart). Creating a scatterplot in Excel is very easy. Displaying my data as a line plot produces similar behavior.Įach data point also has its own label along the x axis, rather than periodically labeling values as is done with the y-axis. Now let's try creating a similar graph in Excel. However, while I would expect (3, 5) and (5, to be twice the distance along the x-axis as (2, 3) and (3, 5) are, they are instead evenly spaced. Each point is correctly drawn along the y axis at y=3, 5, and 8, respectively. I can write a query to associate distinct numeric x and y values, but when I plot these values, the scatterplot is drawn so that all plots are evenly spaced along the x axis.įor instance, I have three points, (2, 3), (3, 5), and (5, 8). I'm trying to create a scatter plot with x and y values, similar to how I would do it in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |