Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Number format changes in chart after closing and opening

when i close my worksheet to save, i reopen it and my number formating within
the data table portion of the chart has changed. For example from $ to %.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4,393
Default Number format changes in chart after closing and opening

I have not seen this happen but here's something to try;
Format the Axis; on the Numbers tab there is a box "linked to source"; click
this to remove the check mark
See if this helps and let us know
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kmysings" wrote in message
...
when i close my worksheet to save, i reopen it and my number formating
within
the data table portion of the chart has changed. For example from $ to %.



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
Slow Opening & Odd Closing ohsix New Users to Excel 1 May 20th 07 05:28 PM
no updates prompt at opening and save changes at closing Shariq Excel Discussion (Misc queries) 3 January 10th 07 01:08 AM
Closing a workbook upon opening another Dave New Users to Excel 3 January 3rd 07 09:57 PM
Error while opening/Closing excel Hari Excel Discussion (Misc queries) 0 November 17th 06 06:55 AM
Event on opening/closing groupings in VBA Dirk Flakowski Excel Discussion (Misc queries) 3 November 29th 05 03:52 PM


All times are GMT +1. The time now is 03:06 PM.

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

About Us

"It's about Microsoft Excel"