Forum Discussion
Create a chart based on multiple datas in the same row
Dear Community, My question is (I believe) very simple to answer, but somehow being pretty new to Excel I cannot figure out how to solve it. I want to create a (pie) chart based on multiple datas ...
It would be interesting to know whether the attached workbook functions on either of your platforms!
I have used 365 functions within locally-named formulas to extract the category and associated values for plotting. Putting such definitions into the SERIES chart function is not a good experience. There are reserved names you can't use and when the chart engine errors it just sits there sulking and doing nothing.
The formulas themselves use array shaping functions to extract every third value from the data.
