data label format not saving in excel 2010

  • Thread starter Thread starter Will
  • Start date Start date
W

Will

Hi,

Long time reader, first time poster. I hope you all can help. I'm trying
to format data labels in a 2 axis column and line chart in excel 2010. The
chart data is drawn from a different document, and in that document all of
the numbers used in the chart are formatted as I'd like them to be seen in
the chart (ex. a click-thru rate is formatted as 13.4% instead of .134.)

I have succeeded in formatting my data labels in the chart correctly, but
whenever I open the document containing the chart without the document
containing the data, the formatting is lost and I'm left with percentages
looking like decimals.

Anyone have any idea how to preserve number formatting in data labels? I'd
prefer not to bring the data into the chart document as it's a project for
work and it would look sloppier.

Also, does anyone know why my acrobat 6.0 can't turn my excel 2010 doc
(charts included) into a pdf?

Thanks so much for you help!

Will
 
Back
Top