Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-22-2020, 09:28 AM
p45cal's Avatar
p45cal p45cal is offline How to show X values on the X axis Windows 10 How to show X values on the X axis Office 2019
Expert
 
Join Date: Apr 2014
Posts: 956
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, 7 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to set specific axis values in graphs Esaylikepie Excel 0 10-16-2016 04:31 AM
How to show X values on the X axis Format Chart X axis - inconsistent values TimTDP Excel 2 12-01-2015 02:56 AM
How to show X values on the X axis X axis does not show Years from data MARENG Excel 8 01-20-2015 10:45 AM
Secondry Axis overlapping in bar chart dual axis in Powerpoint 2010 sharath_ms PowerPoint 0 07-08-2013 10:06 PM
how do I add data values in Col A into X axis on bar graph? hazz Excel 1 04-27-2010 01:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft