Add-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.

Sumit Walia wrote:
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



--
Debra 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,
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.

Sumit Walia wrote:
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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.

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
_______

Debra Dalgleish wrote:

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.

Sumit Walia wrote:

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

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
_______

Debra Dalgleish wrote:

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.

Sumit Walia wrote:

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