Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Why do the fonts for data labels in excel 2007 change when I save for 2003?

I built a file in excel 2003 that uses a Wingdings font for the data labels of a series in order to show up and down arrows. Now I've upgraded to excel 2007, and when I make ANY changes to that file (including hiding a tab or something unrelated to the chart), the up and down arrows instead become the characters that they represent, as if Wingdings has changed to Arial or Verdana. Note that this change is only evident to excel 2003 users - users of excel 2007 still see the up and down arrows?

If I ask an excel 2003 user to make the changes instead, we all see the up and down arrows.

Why does this happen?

Is there a way around it other than having an excel 2003 user implement the changes?

1 Answer

Relevance
  • 1 decade ago
    Favorite Answer

    There really isn't a way around this. The problem is 2007 has a lot more fonts than 2003 does. If you know you are going to need to work in both make sure you are using a compatible (more common) text style.

Still have questions? Get your answers by asking now.