I have a pivot chart and I like to show the data value above the column, however when I resort the chart with a new query, the data labels disappear and I have to go back through format data series/data labels/show value all over again. How do I get the data labels to stay and update automatically based on the new sort

Leroy

This is an admitted deficiency in pivot tables and charts. Next time you
have to redo a chart's formatting, record a macra, then play it back
every time after that.

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

Leroy wrote:

> I have a pivot chart and I like to show the data value above the
> column, however when I resort the chart with a new query, the data
> labels disappear and I have to go back through format data
> series/data labels/show value all over again. How do I get the data
> labels to stay and update automatically based on the new sort?
>
> Leroy