Hi All,

I have created a chart on a userform with VBA and formatted using following code

        With oChrt.Chart
            .SetSourceData Source:=rng
            .ChartType = xlLineStacked
            .ApplyDataLabels xlDataLabelsShowLabelAndPercent
            .HasLegend = False
            .HasTitle = True
            .ChartTitle.Text = "Daily Electricity Consumption"
            'X Axis
            .Axes(xlCategory, xlPrimary).HasTitle = True
            .Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "Days"
            'Y Axis
            .Axes(xlValue, xlPrimary).HasTitle = True
            .Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "MWh"
            .Axes(xlValue, xlPrimary).DisplayUnit = xlThousands
        End With
As you can see in the last line I formatted the Y-axis values by thousands smaller. there is a word 'Thousands' appears on top of my Y-Axis which I want to get rid of. Do you know what code should I use to remove that. Is there something like .Axes.DisplayUnote.Title = False or something like that?

P.S. How can I change the style of the graph to a fancier style or change the background color?

Any help much appreciated.

Thanks,