Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 07-02-2010, 02:30 PM
Cody Cody is offline Embedded Excel Graphs - Custom Formatting Mac OS X Embedded Excel Graphs - Custom Formatting Microsoft Office 2008 for Mac
Embedded Excel Graphs - Custom Formatting
Join Date: Jul 2010
Posts: 1
Cody is on a distinguished road
Exclamation Embedded Excel Graphs - Custom Formatting

My question involves the interaction between MS Word 2008 for Mac and MS Word 2010 for Windows, as well as Excel (same versions/issues). All files are xml.

First, when embedding a line graph from Excel into Word (on MacOSX, Office 2008), I've changed the formatting of the fonts (both size and kind) on the axes and data labels etc.; I've also removed the legend and done some other tweaks. Now, whenever I save the word doc and reopen it on the same machine, all of my custom formatting remains, EXCEPT that the data labels revert to their native format.

To be clear, I've changed (on MacOSX, Office 2008), by:

Formatting Data Labels... --> Font (then, Font changed, Font size changed) --> Number --> edit decimal places AND uncheck "LINKED TO SOURCE"

Despite this, the data labels only always revert to Cambria and the number of decimal places always changes back (the axes/titles remain unchanged).

What is going on?

Also of note, in the Excel file, where the graph came from, Cambria was not the font anyway, so is this Word over-ridding Excel for font, and Excel over-ridding word for number of decimal places? And I changed the number of decimal places (in Word) on the axes but these remain as I formatted them, only the data labels change.

Know to, that I have an embed bar graph, from the same Excel file in the same Word file, formatted it in the exact same way, and it maintains its custom formatting. The line graph changes but the bar graph does not.

Secondly, and far more disturbing, in spite of ANY custom settings I apply in Excel or Word 2008, when they are opened in Office 2010 on a Windows machine, they look completely different and are illegible as a result. This applies to embed graphs in Word, a graph in Excel under its own tab, or a graph overlaid on the sheet that shares its data. I.E., it will add back in legends, remove minor grid lines, change the data labels (they may disappear), colors can be different (not just in "shade" but green --> blue), titles become HUGE, fonts revert back to Cambria (worst font in the history of man) etc etc etc.

How can I force Word/Excel to accept my changes to the formatting between versions and between machines?

(all files are xml)
Reply With Quote

formatting, osx, windows

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating custom tabs for Word & Excel 2003 on a Windows 7 OS Skarab Office 1 07-05-2010 09:23 AM
Embedded Excel Graphs - Custom Formatting Linking graphs from excel Markc PowerPoint 2 05-11-2010 02:17 AM
Excel Error Loading Custom UI XML sumdumgai Office 1 05-10-2010 06:59 PM
Linked graphs printing wrong color StaffsLebowski Word 0 12-15-2009 08:44 AM
Excel not saving all data and formatting TRT Excel 2 04-09-2009 12:51 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 04:16 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd. is not affiliated with Microsoft