Issues with macro updating graph - maybe Mac/PC compatibility

[tombecker1978]

Hi all,

I am having real issues with a spreadsheet.

There are three sheets:

1 input
2 log (which converts the data into a tabular form, macro converts each entry into another line and then wipes the data from the input sheet for the next input)
3 graph (which presents the log into a graph format)

Easy.... however it seems to work fine on my Mac, but then I sent it to a friend to use on a PC and the graph does not update, now on my new Mac it does not work either.

I made the spreadsheet a few years ago, and I haven't used excel since really so I just don't know where to start, any help appreciated.

Macro code is as follows:

Sub Macro3()
'
' Macro3 Macro
'


'
    Sheets("Ranges").Visible = True
    Sheets("Ranges").Select
    Range("a10:M10").Select
    Selection.Copy
    Sheets("EEOI Log").Select
    Range("b500").End(xlUp).Offset(1, 0).Select
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=False
    Selection.PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=False
    Sheets("Ranges").Select
    ActiveWindow.SelectedSheets.Visible = False
    Sheets("EEOI Calculator").Select
    Range("c12").Select
    Selection.ClearContents
    Range("c14").Select
    Selection.ClearContents
    Range("c16").Select
    Selection.ClearContents
    Range("data").Select
    Selection.ClearContents
    Sheets("EEOI Log").Select
    
End Sub
Sub Macro4()
'
' Macro4 Macro
'


'
    Range("C13:E13").Select
    Selection.Copy
    Range("C14").Select
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=False
    Selection.PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=False
End Sub

Its probably not the macro that's the issue, below is a screenshot of the graph page with inputs;

Thanks

Tom