•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Strange referencing issue when creating X/Y Scatter Plot
Our take
Are you facing a strange referencing issue while creating your X/Y scatter plot in Excel? In the provided images, the blue dots represent the data points you’re trying to plot. You’ve correctly designated columns Z and X for your X and Y values, respectively. However, upon generating the graph, Excel defaults to using Portfolio ID from column A as the x-axis values. This unexpected behavior can be frustrating. Let’s explore potential solutions to ensure your scatter plot accurately reflects the intended data points.
Image 1 shows the graph that I'm currently working with. The issue that I'm having is with the Blue Dots.
The Series X and Y values are from columns Z and X in image 2. the X series is column Z and the Y series is column X, which image 3 shows. However, when I click OK and Excel creates the graph, it uses Portfolio ID (Column A in Image 2) as the x-axis values instead of the values in column X as defined, and I'm not sure why.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#rows.com#Excel compatibility#Excel alternatives for data analysis#financial modeling with spreadsheets#Excel alternatives#X/Y Scatter Plot#Excel#graph#Blue Dots#Series X#Series Y#columns#values#Portfolio ID#x-axis#columns Z#columns X#reference issue#data visualization#scatter plot