Why is the text misaligned on my Excel Chart when I try to print to PDF or save as a photo?

Question

When I create a chart in Excel, it looks great!

When I go to save it as an image, or export it to a PDF, the alignment of the text gets messed up.

Please help.

Here is the image of the chart as it looks like in the worksheet. This is how it is supposed to look.

Here is the image of the chart how it looks when I save it as an image or export it to PDF. You can see the text in the legend has shifted up, and so has the text in the data labels.

Answer 1

Hi @Adam VanOsdol

Based on my tests, I can reproduce your issue. But I find a workaround, you may have a try.

Select the outline box of legend, right-click on it > Select "Format Legend" > Choose "Text Affects" under Legend Options, change the Shadow Size to 1.

Do the same for Data Labels.

Then after you print it to the PDF, the chart shown as following:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---