How do I get PivotTable data results to show in columns instead ro
 

In Pivot Tables you have your data that you drag and drop as page, column and
row separators for your data. In the actual data field you can have sum,
count , average,... fields to choose from for what you want to see. This
information always shows results by row. I want to know if you can see the
results in columns. An example would be that I look at Count and average for
my given data. The count is in one row and the average is in the nixt row.
I would like the results to show the count in the first row and the average
to be in the same row , next column. Can this be done and How? I have tried
to use the PivotTable Table Options athat shows rows then columns or columns
then rows, but this does not change anything in my results no matter wich one
I choose.

How do I get PivotTable data results to show in columns instead ro
 

You need to Drag & Drop to make this change.

-Click on one of the grey labels for one of the fields in your Data Area.

-*Carefully* drag that label up and to the right just a *little* bit. (Pivot
the field label on itself *within* the Data Area). Very little movement is
required for this. Barely a twist of the wrist.

Very easy, but you might need a little bit of trial and error practice.

--
HTH,
George


"GeorgeK@Novagard" wrote in
message ...
In Pivot Tables you have your data that you drag and drop as page, column
and
row separators for your data. In the actual data field you can have sum,
count , average,... fields to choose from for what you want to see. This
information always shows results by row. I want to know if you can see
the
results in columns. An example would be that I look at Count and average
for
my given data. The count is in one row and the average is in the nixt
row.
I would like the results to show the count in the first row and the
average
to be in the same row , next column. Can this be done and How? I have
tried
to use the PivotTable Table Options athat shows rows then columns or
columns
then rows, but this does not change anything in my results no matter wich
one
I choose.

How do I get PivotTable data results to show in columns instea
 

I am using Excel 2003. I tried to do what you said but the field either
stays where it is or jumps above the other field. I am doing this in a pivot
table with only two data fields, count and average.They will not show side by
side

"George Nicholson" wrote:

You need to Drag & Drop to make this change.

-Click on one of the grey labels for one of the fields in your Data Area.

-*Carefully* drag that label up and to the right just a *little* bit. (Pivot
the field label on itself *within* the Data Area). Very little movement is
required for this. Barely a twist of the wrist.

Very easy, but you might need a little bit of trial and error practice.

--
HTH,
George


"GeorgeK@Novagard" wrote in
message ...
In Pivot Tables you have your data that you drag and drop as page, column
and
row separators for your data. In the actual data field you can have sum,
count , average,... fields to choose from for what you want to see. This
information always shows results by row. I want to know if you can see
the
results in columns. An example would be that I look at Count and average
for
my given data. The count is in one row and the average is in the nixt
row.
I would like the results to show the count in the first row and the
average
to be in the same row , next column. Can this be done and How? I have
tried
to use the PivotTable Table Options athat shows rows then columns or
columns
then rows, but this does not change anything in my results no matter wich
one
I choose.

How do I get PivotTable data results to show in columns instea
 

I'm using Excel 2003, and while it may require trial and error, it is
possible.

--
HTH,
George


"GeorgeK@Novagard" wrote in
message ...
I am using Excel 2003. I tried to do what you said but the field either
stays where it is or jumps above the other field. I am doing this in a
pivot
table with only two data fields, count and average.They will not show side
by
side

"George Nicholson" wrote:

You need to Drag & Drop to make this change.

-Click on one of the grey labels for one of the fields in your Data
Area.

-*Carefully* drag that label up and to the right just a *little* bit.
(Pivot
the field label on itself *within* the Data Area). Very little movement
is
required for this. Barely a twist of the wrist.

Very easy, but you might need a little bit of trial and error practice.

--
HTH,
George


"GeorgeK@Novagard" wrote in
message ...
In Pivot Tables you have your data that you drag and drop as page,
column
and
row separators for your data. In the actual data field you can have
sum,
count , average,... fields to choose from for what you want to see.
This
information always shows results by row. I want to know if you can see
the
results in columns. An example would be that I look at Count and
average
for
my given data. The count is in one row and the average is in the nixt
row.
I would like the results to show the count in the first row and the
average
to be in the same row , next column. Can this be done and How? I have
tried
to use the PivotTable Table Options athat shows rows then columns or
columns
then rows, but this does not change anything in my results no matter
wich
one
I choose.

How do I get PivotTable data results to show in columns instea
 

Any chance you could send me a file with the example? I tried slowing my
pointer down but still could not accomplish the task. You can send it to
Thanks!

"George Nicholson" wrote:

I'm using Excel 2003, and while it may require trial and error, it is
possible.

--
HTH,
George


"GeorgeK@Novagard" wrote in
message ...
I am using Excel 2003. I tried to do what you said but the field either
stays where it is or jumps above the other field. I am doing this in a
pivot
table with only two data fields, count and average.They will not show side
by
side

"George Nicholson" wrote:

You need to Drag & Drop to make this change.

-Click on one of the grey labels for one of the fields in your Data
Area.

-*Carefully* drag that label up and to the right just a *little* bit.
(Pivot
the field label on itself *within* the Data Area). Very little movement
is
required for this. Barely a twist of the wrist.

Very easy, but you might need a little bit of trial and error practice.

--
HTH,
George


"GeorgeK@Novagard" wrote in
message ...
In Pivot Tables you have your data that you drag and drop as page,
column
and
row separators for your data. In the actual data field you can have
sum,
count , average,... fields to choose from for what you want to see.
This
information always shows results by row. I want to know if you can see
the
results in columns. An example would be that I look at Count and
average
for
my given data. The count is in one row and the average is in the nixt
row.
I would like the results to show the count in the first row and the
average
to be in the same row , next column. Can this be done and How? I have
tried
to use the PivotTable Table Options athat shows rows then columns or
columns
then rows, but this does not change anything in my results no matter
wich
one
I choose.