Reg: Preparing Charts using Pivot Data
 

Hi All
I am tring to Prepare a sales chart of 3number team performance
for the last 2months.
Eg Pivot Data:
Data 1 Month 2 Month
Member1 94157 241782
Member2 93346 237563
Member3 94294 243119
For the above data i want to prepare a single chart which can
show me the values and also "%" of contribution of a individual member in a
perticular month.(X-axis should contain the month, Y-axis should conatin
Values.)

Preparing Charts using Pivot Data
 

Pivot charts plot series in columns. If you want to use a pivot chart,
rearrange the pivot table so months are in the rows area and members in the
columns area.

You can also make a regular chart from a pivot table, if you're careful
defining the data:

http://pubs.logicalexpressions.com/P...cle.asp?ID=553

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Anil" wrote in message
...
Hi All
I am tring to Prepare a sales chart of 3number team performance
for the last 2months.
Eg Pivot Data:
Data 1 Month 2 Month
Member1 94157 241782
Member2 93346 237563
Member3 94294 243119
For the above data i want to prepare a single chart which can
show me the values and also "%" of contribution of a individual member in
a
perticular month.(X-axis should contain the month, Y-axis should conatin
Values.)

Preparing Charts using Pivot Data
 

Dear Jon

Thanx for the reply. As I require the region wise % of
contribution in the same chart as u shown in the firgure. I can't find any
"%" values in the chart given by you.

As per ur chart u r showing the region wise Rep amounts. Now i
need the region wise % values how much they are contibuted (in this same
chart the Y-axis shold conatin values).

"Jon Peltier" wrote:

Pivot charts plot series in columns. If you want to use a pivot chart,
rearrange the pivot table so months are in the rows area and members in the
columns area.

You can also make a regular chart from a pivot table, if you're careful
defining the data:

http://pubs.logicalexpressions.com/P...cle.asp?ID=553

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Anil" wrote in message
...
Hi All
I am tring to Prepare a sales chart of 3number team performance
for the last 2months.
Eg Pivot Data:
Data 1 Month 2 Month
Member1 94157 241782
Member2 93346 237563
Member3 94294 243119
For the above data i want to prepare a single chart which can
show me the values and also "%" of contribution of a individual member in
a
perticular month.(X-axis should contain the month, Y-axis should conatin
Values.)

Preparing Charts using Pivot Data
 

If you need data that isn't in the pivot table to appear in the chart, then
you need to calculate the data outside the pivot table, and create a regular
chart that contains the original data and the calculated data.

Percentages might be done within the pivot table, if you are calculating
percentage of a row or column. The data field has already been added to the
pivot table's data area. Drag another copy of the field from the field list
to the data area, then right click on its label and choose Field Settings,
and choose the appropriate percentage option.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Anil" wrote in message
...
Dear Jon

Thanx for the reply. As I require the region wise % of
contribution in the same chart as u shown in the firgure. I can't find any
"%" values in the chart given by you.

As per ur chart u r showing the region wise Rep amounts. Now i
need the region wise % values how much they are contibuted (in this same
chart the Y-axis shold conatin values).

"Jon Peltier" wrote:

Pivot charts plot series in columns. If you want to use a pivot chart,
rearrange the pivot table so months are in the rows area and members in
the
columns area.

You can also make a regular chart from a pivot table, if you're careful
defining the data:

http://pubs.logicalexpressions.com/P...cle.asp?ID=553

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Anil" wrote in message
...
Hi All
I am tring to Prepare a sales chart of 3number team
performance
for the last 2months.
Eg Pivot Data:
Data 1 Month 2 Month
Member1 94157 241782
Member2 93346 237563
Member3 94294 243119
For the above data i want to prepare a single chart which
can
show me the values and also "%" of contribution of a individual member
in
a
perticular month.(X-axis should contain the month, Y-axis should
conatin
Values.)

Preparing Charts using Pivot Data
 

Dear jon

Thanx for your valuble suggestion. can u please show mw an
example.

"Jon Peltier" wrote:

If you need data that isn't in the pivot table to appear in the chart, then
you need to calculate the data outside the pivot table, and create a regular
chart that contains the original data and the calculated data.

Percentages might be done within the pivot table, if you are calculating
percentage of a row or column. The data field has already been added to the
pivot table's data area. Drag another copy of the field from the field list
to the data area, then right click on its label and choose Field Settings,
and choose the appropriate percentage option.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Anil" wrote in message
...
Dear Jon

Thanx for the reply. As I require the region wise % of
contribution in the same chart as u shown in the firgure. I can't find any
"%" values in the chart given by you.

As per ur chart u r showing the region wise Rep amounts. Now i
need the region wise % values how much they are contibuted (in this same
chart the Y-axis shold conatin values).

"Jon Peltier" wrote:

Pivot charts plot series in columns. If you want to use a pivot chart,
rearrange the pivot table so months are in the rows area and members in
the
columns area.

You can also make a regular chart from a pivot table, if you're careful
defining the data:

http://pubs.logicalexpressions.com/P...cle.asp?ID=553

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Anil" wrote in message
...
Hi All
I am tring to Prepare a sales chart of 3number team
performance
for the last 2months.
Eg Pivot Data:
Data 1 Month 2 Month
Member1 94157 241782
Member2 93346 237563
Member3 94294 243119
For the above data i want to prepare a single chart which
can
show me the values and also "%" of contribution of a individual member
in
a
perticular month.(X-axis should contain the month, Y-axis should
conatin
Values.)

Preparing Charts using Pivot Data
 

Dear Jon

hanx for ur valuble suggestion. Can u please shown a example like
the previous one.



"Jon Peltier" wrote:

If you need data that isn't in the pivot table to appear in the chart, then
you need to calculate the data outside the pivot table, and create a regular
chart that contains the original data and the calculated data.

Percentages might be done within the pivot table, if you are calculating
percentage of a row or column. The data field has already been added to the
pivot table's data area. Drag another copy of the field from the field list
to the data area, then right click on its label and choose Field Settings,
and choose the appropriate percentage option.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Anil" wrote in message
...
Dear Jon

Thanx for the reply. As I require the region wise % of
contribution in the same chart as u shown in the firgure. I can't find any
"%" values in the chart given by you.

As per ur chart u r showing the region wise Rep amounts. Now i
need the region wise % values how much they are contibuted (in this same
chart the Y-axis shold conatin values).

"Jon Peltier" wrote:

Pivot charts plot series in columns. If you want to use a pivot chart,
rearrange the pivot table so months are in the rows area and members in
the
columns area.

You can also make a regular chart from a pivot table, if you're careful
defining the data:

http://pubs.logicalexpressions.com/P...cle.asp?ID=553

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Anil" wrote in message
...
Hi All
I am tring to Prepare a sales chart of 3number team
performance
for the last 2months.
Eg Pivot Data:
Data 1 Month 2 Month
Member1 94157 241782
Member2 93346 237563
Member3 94294 243119
For the above data i want to prepare a single chart which
can
show me the values and also "%" of contribution of a individual member
in
a
perticular month.(X-axis should contain the month, Y-axis should
conatin
Values.)

Preparing Charts using Pivot Data
 

Dear jon
thanx for ur valuble suggestion. Can u please show me a
example like the previous one.




"Jon Peltier" wrote:

If you need data that isn't in the pivot table to appear in the chart, then
you need to calculate the data outside the pivot table, and create a regular
chart that contains the original data and the calculated data.

Percentages might be done within the pivot table, if you are calculating
percentage of a row or column. The data field has already been added to the
pivot table's data area. Drag another copy of the field from the field list
to the data area, then right click on its label and choose Field Settings,
and choose the appropriate percentage option.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Anil" wrote in message
...
Dear Jon

Thanx for the reply. As I require the region wise % of
contribution in the same chart as u shown in the firgure. I can't find any
"%" values in the chart given by you.

As per ur chart u r showing the region wise Rep amounts. Now i
need the region wise % values how much they are contibuted (in this same
chart the Y-axis shold conatin values).

"Jon Peltier" wrote:

Pivot charts plot series in columns. If you want to use a pivot chart,
rearrange the pivot table so months are in the rows area and members in
the
columns area.

You can also make a regular chart from a pivot table, if you're careful
defining the data:

http://pubs.logicalexpressions.com/P...cle.asp?ID=553

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______