Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 129
Default data label format not saving in excel 2010

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving chart templates - xl 2007 (and 2010?) Reg Charts and Charting in Excel 0 January 13th 10 04:36 PM
Excel 2010 - choose codepage when saving as text? Homey Excel Discussion (Misc queries) 0 November 13th 09 01:04 PM
Saving Excel data in tab delimited format to Notepad tcmh Excel Discussion (Misc queries) 1 May 3rd 09 10:37 PM
excel data label format special number characters (part 2) todd Excel Discussion (Misc queries) 1 May 4th 05 04:08 PM
excel data label format special number characters todd Excel Discussion (Misc queries) 0 May 4th 05 01:30 PM


All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"