Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Totals in Stacked Charts in 2007
I have been searching for 2 days with no luck. Is there a way to display the
total on the top of a stacked chart from an OLAP Pivot table. I'm starting to think that since the data is tied directly to the OLAP cube and the subtotals are tied to the underlying data, Excel will not allow you to add the data series in any way. Please help. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Totals in Stacked Charts in 2007
If this were a regular chart, the advice would be to add a line series,
formatted with no lines and no markers, that plots the totals and displays data labels showing these values. Pivot charts do not allow you to add series to them or plot data besides what the pivot chart shows by default. You can make a regular chart from pivot table data. Select a blank cell that doesn't touch the pivot table and insert a chart. Go to Chart Tools Design tab, click Select Data. In the dialog, do not adjust the entry in the Chart Data Range box at the top. Instead, add each series under Legend Entries, choosing its data as you go. This regular chart permits some formatting and other options not allowed in a pivot chart, but does not adjust to a resized pivot table. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Carmaboy" wrote in message ... I have been searching for 2 days with no luck. Is there a way to display the total on the top of a stacked chart from an OLAP Pivot table. I'm starting to think that since the data is tied directly to the OLAP cube and the subtotals are tied to the underlying data, Excel will not allow you to add the data series in any way. Please help. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Totals in Stacked Charts in 2007
Thanks a lot for the response. This worked. Is there a particular
reason why MS didnt not allow this to be an innate functionality of a stacked charted using Pivot tables? Can anyone think of a technical or logical reason why this isnt a default behavoir/option? Thanks again. On Nov 21, 9:55 am, "Jon Peltier" wrote: If this were a regular chart, the advice would be to add a line series, formatted with no lines and no markers, that plots the totals and displays data labels showing these values. Pivot charts do not allow you to add series to them or plot data besides what the pivot chart shows by default. You can make a regular chart from pivot table data. Select a blank cell that doesn't touch the pivot table and insert a chart. Go to Chart Tools Design tab, click Select Data. In the dialog, do not adjust the entry in the Chart Data Range box at the top. Instead, add each series under Legend Entries, choosing its data as you go. This regular chart permits some formatting and other options not allowed in a pivot chart, but does not adjust to a resized pivot table. - Jon ------- Jon Peltier, MicrosoftExcelMVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "Carmaboy" wrote in message ... I have been searching for 2 days with no luck. Is there a way to display the total on the top of a stacked chart from anOLAPPivot table. I'm starting to think that since the data is tied directly to theOLAPcube and the subtotals are tied to the underlying data,Excelwill not allow you to add the data series in any way. Please help.- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Totals in Stacked Charts in 2007
Pivot charts have particular capabilities, and to support these
capabilities, certain features of regular charts must be left out. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... Thanks a lot for the response. This worked. Is there a particular reason why MS didnt not allow this to be an innate functionality of a stacked charted using Pivot tables? Can anyone think of a technical or logical reason why this isnt a default behavoir/option? Thanks again. On Nov 21, 9:55 am, "Jon Peltier" wrote: If this were a regular chart, the advice would be to add a line series, formatted with no lines and no markers, that plots the totals and displays data labels showing these values. Pivot charts do not allow you to add series to them or plot data besides what the pivot chart shows by default. You can make a regular chart from pivot table data. Select a blank cell that doesn't touch the pivot table and insert a chart. Go to Chart Tools Design tab, click Select Data. In the dialog, do not adjust the entry in the Chart Data Range box at the top. Instead, add each series under Legend Entries, choosing its data as you go. This regular chart permits some formatting and other options not allowed in a pivot chart, but does not adjust to a resized pivot table. - Jon ------- Jon Peltier, MicrosoftExcelMVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "Carmaboy" wrote in message ... I have been searching for 2 days with no luck. Is there a way to display the total on the top of a stacked chart from anOLAPPivot table. I'm starting to think that since the data is tied directly to theOLAPcube and the subtotals are tied to the underlying data,Excelwill not allow you to add the data series in any way. Please help.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - percentage and values on 100% line/column stacked charts | Charts and Charting in Excel | |||
Totals in Stacked Column? | Charts and Charting in Excel | |||
Stacked Column graphs reflecting net totals | Charts and Charting in Excel | |||
How do I fix my Stacked column chart with grand totals? | Charts and Charting in Excel | |||
Charting: Displaying cumulative totals at top of stacked columns | Charts and Charting in Excel |