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,
Bookmarks