Forum Discussion
why excel always put value of 1 when adding values in series
when I create a chart, I start adding the series in respective manner, I found that when I add new series, the series value filed always by default shows this value in the field = {1}, which every ti...
I'm not sure how your are doing this (exact steps) but I will often create a chart and then to add a new series I will highlight the data and copy and then on the chart i will paste special and then I can define it a new series and there are options to use existing X values or use the first column. not sure if that helps/applies to your case.