Consulting

Results 1 to 1 of 1

Thread: Legend Issue

  1. #1
    VBAX Newbie
    Joined
    Dec 2018
    Posts
    1
    Location

    Legend Issue

    I copied a spreadsheet from someone else and now the legend expands into the C3 cell. It works doesn't show on their copy.
    Capture.PNG

    Sub UPDATEOEECHART()
    ' UPDATEOEECHART Macro
    ActiveSheet.ChartObjects("Chart 2").Activate
        ActiveChart.PlotArea.Select
        ActiveChart.SetSourceData Source:=Sheets("Data History").Range( _
            "A1:A3,B1:AA3,A10:A12,B10:AA12")
        Range("V1").Select
    End Sub
    Last edited by Aussiebear; 12-15-2018 at 04:30 PM. Reason: Added tags to code

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •