Forum Discussion

meto343's avatar
meto343
Copper Contributor
Aug 02, 2022
Solved

Macro Error at Specific Range

Hello,   My macro code throws an error when there are less than 5 values in the x-axis of the table.   I want to convert the following table to chart (grafik getir means get the chart in Turkish)...
  • meto343's avatar
    Aug 02, 2022

    This is how I solved my problem:

    By adding the code 'grafik.Chart.PlotBy = xlColumns'.

    in general
    ' ChartObjects(1).Chart.PlotBy = xlColumns '