View Single Post
 
Old 11-22-2020, 09:28 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

You can cheat. See attached, button and notes in the code.
Code:
Sub blah()
Sheets("Foglio1").Copy After:=Sheets(Sheets.Count)    'makes a copy of the sheet; remove when development finished.
With ActiveSheet.ChartObjects("Grafico 1").Chart
  PlotTop = .PlotArea.Top
  OrigTop = .Axes(xlCategory).Top
  .Axes(xlCategory).MajorGridlines.Delete
  .Axes(xlCategory).Delete
  .PlotArea.Top = PlotTop - 10
  .FullSeriesCollection(1).ApplyDataLabels
  With .FullSeriesCollection(1).DataLabels
    .ShowCategoryName = True
    .ShowValue = False
    .Position = xlLabelPositionBelow
  End With
  For Each pt In .FullSeriesCollection(1).DataLabels
    pt.Top = OrigTop
  Next pt
End With
End Sub
Attached Files
File Type: xlsm msofficeforums46013example.xlsm (23.6 KB, 5 views)
Reply With Quote