phoenix-excel
New Member
- Joined
- Apr 28, 2011
- Messages
- 1
Hey everybody,
I am working with Excel 2007.
I have created a survey, with about 30 questions. I am trying to analyze my results with the Pivot table. The results are always separated by the nationality of the survey taker (2 possiblities)
Here is the problem:
I want my results shown in percentage of the row. For example 32.1%.
I am also tryin to get a chart for each questions.
So if I saved the chart for one question, I change the "column" and "result" section of the Pivot table with the next question.
however, it sets back EVERY TIME to absolute numbers. so every time I have to change it back to percentage, and then adjust the number of digits from 2 to 1.
can you tell me how to avoid that? I tried every option that I could find...
thanks!!! I am going crazy here..
I am working with Excel 2007.
I have created a survey, with about 30 questions. I am trying to analyze my results with the Pivot table. The results are always separated by the nationality of the survey taker (2 possiblities)
Here is the problem:
I want my results shown in percentage of the row. For example 32.1%.
I am also tryin to get a chart for each questions.
So if I saved the chart for one question, I change the "column" and "result" section of the Pivot table with the next question.
however, it sets back EVERY TIME to absolute numbers. so every time I have to change it back to percentage, and then adjust the number of digits from 2 to 1.
can you tell me how to avoid that? I tried every option that I could find...
thanks!!! I am going crazy here..
