I have an application that uses three data series. One to display the actual
data (x and y values) in a column format and the other two to show "average"
values for the whole company (taken from a field on another tab) and for the
current data. The actual data it's average is held in a pivot table but the
series data is set from VB (the chart is not a pivotchart). In the pivot
table change event the data series values are refreshed by looping around the
cells covered by the table. The two average lines show but the data values
disappear. This worked fine in Excel2003.

Thanks

Are the averages data labels? Are the labels explicitly added, populated,
and formatted in the code?

Without seeing the relevant code, it's hard to determine what might be wrong
with it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"chris mason" wrote in message
...
I have an application that uses three data series. One to display the
actual
data (x and y values) in a column format and the other two to show
"average"
values for the whole company (taken from a field on another tab) and for
the
current data. The actual data it's average is held in a pivot table but
the
series data is set from VB (the chart is not a pivotchart). In the pivot
table change event the data series values are refreshed by looping around
the
cells covered by the table. The two average lines show but the data values
disappear. This worked fine in Excel2003.

Thanks