Hi,
I'm having some trouble getting excel to show the right values in a graph I'm trying to make. I have columns with 35 values each and when I plot then in an XY scatter plot excel decides to make the X axis 1-35 rather than what I have in the X column. Any idea why this might be happening? When I use the line graph option it works just fine, but this forces me to use the same X values for all lines and I'm trying to superimpose 2 trend lines and so need separate X value columns.
Thank You!!!
I didn't find the right solution from the Internet.
References
https://social.msdn.microsoft.com/Forums/office/en-US/92ed6805-c58d-41e0-b717-15482357cc59/xy-scatter-plot-not-using-proper-x-values?forum=exceldev
