How to retain format for linked data source

M

Metcare

I created a chart whose data source is linked from 4 different workbooks.
When I open the worksheet where the chart is, the format ( in percentage(%) )
of the data has been changed. How can I retain the format of the chart data
based on the linked source data . Appreciate your help. Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Excel 2010 Data Labels options not saving 0
Address Format changed after Migration 0
Odd Chart Format Results 1
Excel 2013 Copying pivot charts to PowerPoint 0
Chart Location Impact On Links When Copying To New Workbook 1
how to retain data in table only but do not graph of that data 1
Refresh Pivot Chart with Table? 0

Top