View Single Post
  #3   Report Post  
Old October 10th 08, 03:31 PM posted to microsoft.public.excel.charting
kermit kermit is offline
external usenet poster
First recorded activity by ExcelBanter: Mar 2007
Posts: 12
Default Chart won't hold formatting

Thanks for the idea Christopher, but it won't solve my problem, as the excel
chart won't keep the formatting in excel itself. If I change data labels font
size, color, ect and then save, close and reopen, the data labels have
reverted back to the default.

"Christopher Scott [MSFT]" wrote:

If you do a regular Ctrl+C then Ctrl+V paste into PowerPoint I think there
should be a little icon at the bottom right of the chart. If you drop that
down there should be an option called "use source formatting" or something
like that. Does that work? I can't check right now as I'm at home.

This posting is provided "AS IS" with no warranties, and confers no rights.

"Kermit" wrote:

Excel 2007. I am trying to change the font size of data labels on a line
chart. Also changing the color of the lines. After making the changes and
saving the spreadsheet, if I close and reopen the sheet, the data labels and
line colors have reverted to default size, fonts, and color.

I need to put these charts in a powerpoint. When copying into power point
all formats also revert to default. Using Powerpoint 2007. Doesn't matter
what type of paste either. paste, paste link, or paste special. png, jpg, or
metafile all revert to default once pasted into powerpoint.

Presentation is Monday, Please help!!!