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 ti...
Charting
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