Thread: Unwanted data change with scatter charts

I am trying to plot an X,Y data using scatter chart, but I do not know, why excel is changing the series data values
I am plotting the values range x and y, but instead excel is changing the x’s value for 1,2,3,….
Every time that I open the chart’s data source, they are ok, but not in the chart.
I wonder if I can attach the excel file, but as far I can see is not possible. That will be helpful to show the unwanted situation
Thanks a lot

You can zip the workbook and then attach the file, making sure there is no sensitive information contained therein of course

Thanks for the suggestion.
Here are two files one is named 49 and the other one 20
this is to show what the problem is:
file 49, shows the chart wihthout problem.
49 is the value for cell F1 in scheet 2
so the X,Y values =SERIES("PW1";'2'!$D$9:$D$57;'2'!$E$9:$E$57;2) from sheet 2 are correctly plotted

and file 20 is when the value in cell F1 in sheet 2 is changed to 20, so the data serie chart still =SERIES("PW1";'2'!$D$9:$D$57;'2'!$E$9:$E$57;2) but the chart instead of X1,y1:X2,y2....shows 1,y1:2,y2....

thanks a lot for any help to solve this.

Originally Posted by mmf

I am trying to plot an X,Y data using scatter chart, but I do not know, why excel is changing the series data values
I am plotting the values range x and y, but instead excel is changing the x’s value for 1,2,3,….
Every time that I open the chart’s data source, they are ok, but not in the chart.
I wonder if I can attach the excel file, but as far I can see is not possible. That will be helpful to show the unwanted situation
Thanks a lot

The usual reason Excel converts X data to {1,2,3,...} is because it interprets the first column as text or something else that it can't interpret as a number. Make sure all of the values in your x data are truly numbers. No "numbers stored as text", or error values, or text values or the like.

The x cell has a formula as follow
=IF(B10="";"";$B$6-$AB$4)
so if B do not have any value, X will be ""

the things is that originally i Set the chart for the full range of b which are 49 values.
but when I change the value in the cell F1, which generate all B values, to 20
I only have 20 values and the rest will "", so that is probably what is causing the trouble

So will be possible to set the chart data range linked to the value of F1? so any time that I vary that value, the data range has just numeric values?
thanks

Despite tha advice I am not reachin any solution, any other suggestions?

If I understand what you are doing, I think what you want is to use named ranges for X and Y. I don't use the feature, so I have no experience with it, but I thought I recall seeing discussions about making named ranges "dynamic" so that it changes as needed. See if that will help you.