Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 31st 09, 04:42 PM posted to microsoft.public.excel.charting
GLM GLM is offline
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 5
Default Format Data Labels Doesn't Save

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   Report Post  
Old December 31st 09, 06:02 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default Format Data Labels Doesn't Save

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   Report Post  
Old December 31st 09, 06:39 PM posted to microsoft.public.excel.charting
GLM GLM is offline
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 5
Default Format Data Labels Doesn't Save

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How select all data points/data labels at once (to format)? kippers Charts and Charting in Excel 2 April 1st 09 02:29 PM
Format data labels for the whole chart? Ian R Charts and Charting in Excel 3 January 15th 07 10:36 PM
How do I format the data labels in my stacked bar graph? ocjred Charts and Charting in Excel 2 August 2nd 06 04:05 PM
data labels change format john mcmichael Charts and Charting in Excel 1 March 16th 06 04:17 PM
How can I change the position/format for all data labels in a ser. PearlBeast Charts and Charting in Excel 3 December 7th 04 08:07 PM


All times are GMT +1. The time now is 01:05 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017