Format issues in the data table of a chart

Karenola

New Member
Joined
Oct 10, 2006
Messages
1
I have a chart (showing the data table) that is linked to another spreadsheet. When that linked spreadsheet is open, the numbers in the data table show as percents, which is what I want. But when that linked spreadsheet is closed, the numbers in the data table become decimals, losing the percentage format. Do you know why that happens and how I can fix it? Thank you
Whoops. I meant to add that I have posted this at Experts-Exchange. I got one reply but it is not what I need.
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,118,852
Messages
5,574,660
Members
412,608
Latest member
Guromir
Top