Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Save problem for linked excel spreadsheet | Excel Discussion (Misc queries) | |||
Saving an file with charts as a webpage - border problem | Excel Discussion (Misc queries) | |||
In a linked calculation how do I lose the '0' in the linked file? | Excel Worksheet Functions | |||
linking a file to another linked file in excel | Excel Discussion (Misc queries) | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel |