How to anchor data label show value option on Pivot Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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/
_______
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inside Base Series Label Showing #N/A 0
Pivot Chart Data labels 1
Pivot chart series label 1
Excel 07 - Stacked Chart Labels on Negative Values 1
How to embed expression in data labels on a chart 2
automation moves data label 1
How to have data labels follow time adjusting line charts? 0
Macro to change position of chart labels on line chart 1

Back
Top