Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Table Chart no longer works with Office:MAC 2008
I have recently upgraded to Office:MAC 2008 and my pivot table chart has
stopped working. The pivot table is updated automatically from external data and the table itself is fine. The formerly working chart, however, has 2 problems: 1) The data range no longer automatically changes with the corresponding change in size of the pivot table. Each day an additional line of data is added, however, the range on the chart is static and has to manually be changed daily. I cannot seem to come up with a format that will work. Here is a typical range for a series: Name: 'Pivot Table'!$B$2 Y-Values: 'Pivot Table'!$B$3:$B$211 My question is what format do I use for the Y-Values so that the range follows the pivot table ('Pivot Table'!$B$3 does not work). 2) The labels for the Y-Axis has a similar problem. My Y-Axis are the dates corresponding to the above data. However, the dates displayed only go up to the date when I did the upgrade. After that there are no dates displayed. I cannot find any settings that let me specify the range of the Y-Axis data. Indeed, I cannot even find where the specification fo the Axis is. When I double click that region of the chart, all I can see are various formatting settings. Can someone point me in the right direction with these two problems? I suspect it is just me not knowing where to look for these settings (the built-in help is virtually useless) as 2008 is quite different then previous versions. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Table Chart no longer works with Office:MAC 2008
gw1500se -
According to a post in microsoft.public.mac.office.excel: "Pivot charts are not available in Macintosh Excel." - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "gw1500se" wrote in message ... I have recently upgraded to Office:MAC 2008 and my pivot table chart has stopped working. The pivot table is updated automatically from external data and the table itself is fine. The formerly working chart, however, has 2 problems: 1) The data range no longer automatically changes with the corresponding change in size of the pivot table. Each day an additional line of data is added, however, the range on the chart is static and has to manually be changed daily. I cannot seem to come up with a format that will work. Here is a typical range for a series: Name: 'Pivot Table'!$B$2 Y-Values: 'Pivot Table'!$B$3:$B$211 My question is what format do I use for the Y-Values so that the range follows the pivot table ('Pivot Table'!$B$3 does not work). 2) The labels for the Y-Axis has a similar problem. My Y-Axis are the dates corresponding to the above data. However, the dates displayed only go up to the date when I did the upgrade. After that there are no dates displayed. I cannot find any settings that let me specify the range of the Y-Axis data. Indeed, I cannot even find where the specification fo the Axis is. When I double click that region of the chart, all I can see are various formatting settings. Can someone point me in the right direction with these two problems? I suspect it is just me not knowing where to look for these settings (the built-in help is virtually useless) as 2008 is quite different then previous versions. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Table Chart no longer works with Office:MAC 2008
"Mike Middleton" wrote: gw1500se - According to a post in microsoft.public.mac.office.excel: "Pivot charts are not available in Macintosh Excel." - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel Well that really sucks. I wonder why it was removed? I guess I need to go back to the previous version of Office. Thanks for the info. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Table Chart no longer works with Office:MAC 2008
gw1500se -
I wonder why it was removed? < The PivotChart feature has never been available in Mac Excel. It was never implemented in Mac Excel X, Mac Excel 2004, or Mac Excel 2008. - Mike "gw1500se" wrote in message ... "Mike Middleton" wrote: gw1500se - According to a post in microsoft.public.mac.office.excel: "Pivot charts are not available in Macintosh Excel." - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel Well that really sucks. I wonder why it was removed? I guess I need to go back to the previous version of Office. Thanks for the info. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export chart to GIF no longer works after installing Excel 2007b2 | Charts and Charting in Excel | |||
ALT+ENTER no longer works | Excel Discussion (Misc queries) | |||
New Computer HPVAL no longer works | Excel Worksheet Functions | |||
How do I Clear old Pivot Table Fields that no longer exist | Excel Discussion (Misc queries) | |||
Office 2003 - "autocomplete" in file | open or file | save no longer works | Excel Discussion (Misc queries) |