How do I get my data labels on a pivot chart to retain their form.

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

Guest

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

Delete multiple chartobjects from one chart sheet 0
Change ALL chart elements default font? 2
data labels change format 1
How Do I Nail Down Chart Width for Printing 2
x-axis scale changes 3
Pivot charts formatting 1
Changing font style/size/color/etc for multiple series in a chart? 3
Pivot chart series label 1

Back
Top