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.)