I am trying to make some radar charts that have more than 30 criteria. My
data contains numbers between 0 and 1. Each time that I add each criteria to
the data field, it automatically comes up as Count...I can switch each one to
Sum (which is a pain) but then each data point is labeled Sum of something.

Ideally, I would automatically have Sum results that are labeled with by my
choosing.

Example.

I would like to have a typical data point be labeled Total Portfolio, I am
stuck as excel automatically gives me Count of Total Portfolio which I then
have to Switch to Sum of Total Portfolio. Is there away to overcome this
annoyance??


Thanks- MR(Novice)