Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Percentage format in pasted chart data table and axis will change to Numeric when source workbook is closed

Percentage format in pasted chart data table and axis will change to Numeric when source workbook is closed

Symptoms

Assume below scenario:

  1. Create test1.xlsx, input some data with % format.
  2. Create a chart based the data, then show data table from Chart Tools->Layout->Data table->Show Data Table
  3. Create a new workbook, named test2.xlsx
  4. Copy chart from test1.xlsx to test2.xlsx

When you close test1.xlsx, in test2.xlsx you will find percentage (%) format in chart data table and axis changes to numeric format.

↑ Back to the top

Cause

By default, data table and axis formatting of pasted chart are linked to source workbook. Once the source workbook is closed, the link is lost, and hence percentage (%) format is changed to default numeric format.

↑ Back to the top

Resolution

For axis , you can avoid this issue by unlinking the axis formatting:

  1. Right click axis in chart
  2. Click Format Axis
  3. Click Number tab
  4. Uncheck "Linked to Source" checkbox

For data table, it is always linked to source data so the issue cannot be avoided.

↑ Back to the top

Keywords: vkball, kb

↑ Back to the top

Article Info
Article ID : 2480833
Revision : 1
Created on : 1/8/2017
Published on : 2/17/2012
Exists online : False
Views : 116