Forum Discussion

ra7's avatar
ra7
Copper Contributor
Oct 24, 2025

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 time I have to delete it before I choose my values from the worksheet. How to avoid this issue as it is struggling and slowing my work.

I believe it can be avoided.

Charting

2 Replies

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Oct 26, 2025

    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.

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Oct 26, 2025

    Maybe a VBA macro can help you...here is an example

    Sub AddSeriesFast()
    Dim cht As Chart
    Set cht = ActiveSheet.ChartObjects("Chart 1").Chart
    cht.SeriesCollection.NewSeries
    cht.SeriesCollection(cht.SeriesCollection.Count).Values = Range("B2:B10")
    cht.SeriesCollection(cht.SeriesCollection.Count).Name = Range("B1")
End Sub

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

Resources