How do I get my data labels on a pivot chart to retain their form.
I have created a pivot chart as an objecct in another worksheet. The data
labels are on the chart in a font larger than I want (Arial 19). I can click on each of the series, and reduce the font to Arial 10, but as soon as I refresh the chart, the font goes back up to Arial 19. The default font for my excel spreadsheet is Arial 10. |
Loss of formatting is a known problem with pivot charts. There's
information in the following MSKB article, suggests recording a macro as you apply the formatting: XL2000: Changing a PivotChart Removes Series Formatting http://support.microsoft.com/?id=215904 s de maia wrote: I have created a pivot chart as an objecct in another worksheet. The data labels are on the chart in a font larger than I want (Arial 19). I can click on each of the series, and reduce the font to Arial 10, but as soon as I refresh the chart, the font goes back up to Arial 19. The default font for my excel spreadsheet is Arial 10. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 07:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com