Linked graph decimal problems

[BeExcellant]

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?

 

[bbotzong]

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]

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.