Format Data Labels Doesn't Save

G

GLM

Happy New Year!!!

I have a line chart with one line which represents the average of the values
for other column the the original spreadsheet. I selected one of the data
points on the average line and checked the box to "Add Data Label". The data
label displays the value properly. Then I added a fill color, border color
and 3-D format. This displays properly however when I save it, close Excel
and then reopen the chart, the formatting for the data label is gone. The
value displays properly but with no formatting.

Have any of you seen this issue? Is there a way around this?
 
G

GLM

Never mind!!!! I have had this problem for a couple of months and after
entering the question, on a whim I attempted to reproduce it. Of course,
this time it worked. I'm not sure why though.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlier data point for Chart in Excel 1
Multi-Level Category Labels 1
Custom Formatting a Chart Data Label 1
Macro to change position of chart labels on line chart 1
Data labels on chart 1
Data label area in printout 1
Can I realign all data labels in a chart at once 1
Data Labels - I Only Want One 1

Top