Hi. I have 5 columns in a Excel sheet. I want the sum of the respective column data by yearwise in a pie chart. How do i display it?

[#1]

Pls help me over the above problem.

[alkesh_sharma]

DImention = Year

Expression = SUM(Column)

[#3]

Hi Ganesh,

What are the 5 columns?

[#4]

okay, let me rephrase the question. can i have multiple expression used in pie chart?????? pls help me out

Thanks in advance

[alkesh_sharma]

A pie chart can take only one expression. Unless the second is the same with with relative data points.

[#6]

hi Ganesh, plesae attach a model of the data set you are working with, it might be neccesary for you to do some coding, it often is when considering time. however the more thought all put into the model the less coding will be required and the more powerfull will be the available analysis, rgds, Clive

[#7 · Accepted solution]

We can have maximum 2 expression in pie chart. But if we put 2 expression then we will have pie inside pie. So you can use cyclic for this.