Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.) |
#7
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 _______ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
preparing pivot fields for copying and paste special for sorting | Excel Discussion (Misc queries) | |||
Several Pivot Charts One Sheet of Data | Charts and Charting in Excel | |||
Data Area of Pivot Table and Pivot Charts | Charts and Charting in Excel | |||
Help with pivot charts and data labels | Charts and Charting in Excel |