Linked graph decimal problems

BeExcellant

New Member
Joined
Jun 17, 2020
Messages
7
Office Version
  1. 2013
Platform
  1. Windows
Hi everyone - I'm having a problem with a graph in one spreadsheet that's linked to a graph in another spreadsheet showing the wrong number of decimal places.

So here's what's going:

- I copy and paste the graphs from one spreadsheet into another spreadsheet
- The graph has a data table with whole/round numbers in the origin spreadsheet
- When the worksheets are open together, both graphs show the numbers as they should be
- When I close the worksheet with the origin graph, the graph in the second worksheet changes its formatting to numbering that has decimals
- I've tried everything I can think of from formatting the axis of the original and copied graphs, formatting the cells where the data is coming from to be round numbers, and changing the formatting code in the format axis option of the graphs

Any idea how to fix this decimal error?
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

bbotzong

Board Regular
Joined
Dec 17, 2003
Messages
51
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
  5. 2010
Platform
  1. Windows
Try right-clicking on a vertical axis number and selecting Format Axis. In the property box on the right, click the Graph icon and you should see Axis Options, Tick Marks, Labels, and Number. Expand Number and format your axis.

Hope this helps.
 

BeExcellant

New Member
Joined
Jun 17, 2020
Messages
7
Office Version
  1. 2013
Platform
  1. Windows
Try right-clicking on a vertical axis number and selecting Format Axis. In the property box on the right, click the Graph icon and you should see Axis Options, Tick Marks, Labels, and Number. Expand Number and format your axis.

Hope this helps.
Thanks - this was one of the things I tried, and for some reason it just doesn't work on the sheet I need it to. Might just have to come back to this and tinker with it later.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,750
Messages
5,574,007
Members
412,562
Latest member
woodportaj
Top