 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / November 2003Add-In for Pivot chart in MS Excel 97
Hi, I have created some Pivot charts in MS Excel 2000 with page level fields. But my customer uses Excel97 and he is not able to see the Page level fields and cannot see different views of data. It seems that Pivot charts were not available in Excel 97. Only Pivot tables were available. Does anyone know of any add-in for Pivot chart that my customer can use in Excel 97 and is able to view the pivot charts as they are available in Excel 2000. or if there is any other workaround, please let me know. I'll appreciate an early response to this message as this is very urgent. Regards, Sumit Your customer should be able to see the page fields that you've added, as those are available in Excel 97. PivotCharts aren't available in Excel 97, but existing PivotCharts will be visible as normal charts. If the customer needs the functionality of PivotCharts he'll have to upgrade to a newer version of Excel. > Hi, > I have created some Pivot charts in MS Excel 2000 with [quoted text clipped - 14 lines] > Regards, > Sumit  SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html Hi, No, my customer is not able to see those drop down buttons at the page level. Even i checked those excel files in Excel 97 and i was not able to see those drop down buttons. Thanks and regards, Sumit >-----Original Message----- >Your customer should be able to see the page fields that you've added, [quoted text clipped - 22 lines] >> Regards, >> Sumit The fields are visible in the pivot table, but the chart will not show them. And since pivot charts are created as chart sheets by default, the customer will not have the rest of the sheet in the background. Also, I seem to recall that pivot charts that are converted to regular charts in Excel 97 are not linked to any data in the sheet. Instead the data is converted to arrays in the series formula. It might be better to make regular charts in the original workbooks, so they are compatible in Excel 97. These have more "functionality" than pivot charts anyway. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ > Your customer should be able to see the page fields that you've added, > as those are available in Excel 97. [quoted text clipped - 19 lines] >> Regards, >> Sumit The fields are visible in the pivot table, but the chart will not show them. And since pivot charts are created as chart sheets by default, the customer will not have the rest of the sheet in the background. Also, I seem to recall that pivot charts that are converted to regular charts in Excel 97 are not linked to any data in the sheet. Instead the data is converted to arrays in the series formula. It might be better to make regular charts in the original workbooks, so they are compatible in Excel 97. These have more "functionality" than pivot charts anyway. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ > Your customer should be able to see the page fields that you've added, > as those are available in Excel 97. [quoted text clipped - 19 lines] >> Regards, >> Sumit |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.