Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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? -- GLM |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
It sounds as if you re-opened the file in a location different from where
you saved it. -- David Biddulph GLM wrote: 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? |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. -- GLM "GLM" wrote: Happy New Year!!! I have a line chart with one line which represents the average of the values for another column in 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? -- GLM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How select all data points/data labels at once (to format)? | Charts and Charting in Excel | |||
Format data labels for the whole chart? | Charts and Charting in Excel | |||
How do I format the data labels in my stacked bar graph? | Charts and Charting in Excel | |||
data labels change format | Charts and Charting in Excel | |||
How can I change the position/format for all data labels in a ser. | Charts and Charting in Excel |