Posted to microsoft.public.excel.misc
|
|
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
_______
|