Add-In for Pivot chart in MS Excel 97

  • Thread starter Thread starter Sumit Walia
  • Start date Start date
S

Sumit Walia

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,
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
 
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
 
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
 
Back
Top