•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
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]
Want to read more?
Check out the full article on the original site
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