CODEWITHSUNDEEP
excelchartsexcel-formula
Le-Mr-Ruyk
Le-Mr-Ruyk

Reputation: 179

Excel Charts Series function based on cell value

There is any way to plot a chart in excel based on a cell value ?

=SERIES('Sheet1'!$W$34;'Sheet1'!$A$35:$A$39;'Sheet1'!$W$35:$W$39;1)

Can we replace the params of the function with a string from another cell ? Like that:

=SERIES($X$2)

Assuming that X2 contains a string

Thanks.

Upvotes: 0

Views: 847

Answers (1)

bzimor
bzimor

Reputation: 1628

No, you can't. This is because SERIES() is in sheet formula, it's just function styled and only writing arguments for charts and alternative to chart creating form. And you can check this link. However you can use named ranges in it. Check this link to get example dynamic chart

Upvotes: 1

Related Questions