Remove Chart Legends Without Data

[YCJ]

Hi all

I have a template that I have done that will be filled with data after i run my macro. In the same template, but different worksheet, I have my chart that will collect the data to plot it out. I have reserved 60 columns in my template to store the data, and my chart will collect the data from those 60 columns. However, it is not necessary that I will have 60 data to fill in those columns, I might have only 35 data, depending on the user. In this case, my chart will have 25 legends without any data. My question is, can I remove those "empty" legends by making the 25 columns in my datasheet hidden using my macro??
Any guidance or any ideas are greatly appreciated....

Thanks,
CJ

 

[YCJ]

To further clarify, I do not mean to hide the columns, as in "making them disappear", but to ".FormulaHidden = True", because I can't hide the whole columns, there's still a title on top of the page.

Thanks,
CJ

 

[Rasm]

I dont follow why you have so many legends - seem you will chart with a lot of unnecessary nothing - any hooottt

But go ahead and delete legends - dont have any effects - but you have to delete highest first

so something like code below -

    ActiveSheet.ChartObjects(NumCharts).Activate
    Dim Achart As ChartObject
    Set Achart = ActiveSheet.ChartObjects(NumCharts)
    
    With Achart.Chart
          'your code here
          For iii = 60 To 35 Step -1
            .Legend.LegendEntries(iii).Delete
          Next iii
    End With

 

[Rasm]

Hidding columns has no bearing on what is charted - you only hide them from Humans - not the code - unless you explicitly say so

 

[YCJ]

Okay then, Thanks for your info. I'll find other ways to fill my data in.

CJ