Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Sue Sue is offline
external usenet poster
 
Posts: 285
Default I have a problem with charts linked to another excel file.

I have a chart file that is linked to another file with the data. I cannot
get the chart file to keep the format that I want. I keeps changing to show
decimals and no commas.

--
Accounting Manager
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default I have a problem with charts linked to another excel file.

Double click the text element that keeps changing its format. On the Number
tab of the Format dialog, uncheck the Linked to Source checkbox and select
an appropriate format. It should remain unchanged from now on.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Sue" wrote in message
...
I have a chart file that is linked to another file with the data. I cannot
get the chart file to keep the format that I want. I keeps changing to
show
decimals and no commas.

--
Accounting Manager



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
Save problem for linked excel spreadsheet Meltad Excel Discussion (Misc queries) 2 September 13th 06 04:27 PM
Saving an file with charts as a webpage - border problem Sarah Excel Discussion (Misc queries) 0 June 28th 06 01:27 PM
In a linked calculation how do I lose the '0' in the linked file? Anita Excel Worksheet Functions 2 February 3rd 06 01:54 PM
linking a file to another linked file in excel buckeye Excel Discussion (Misc queries) 1 November 10th 05 12:53 AM
Excel Charts Linked to Spreadsheets Rich Charts and Charting in Excel 1 July 4th 05 04:36 PM


All times are GMT +1. The time now is 10:13 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"