Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-10-2017, 01:30 PM
Anitha Anitha is offline Chart Fit to Content Windows 10 Chart Fit to Content Office 2013
Novice
Chart Fit to Content
 
Join Date: Nov 2017
Posts: 6
Anitha is on a distinguished road
Default Chart Fit to Content


Hi,

Chart Legend content is not shown fully due to its size.
Is there any option to fit to content for chart instead of manually changing its size. Since we have many charts in each document.
Attached Files
File Type: docx Hidden Legend.docx (42.1 KB, 12 views)

Last edited by Anitha; 12-10-2017 at 01:32 PM. Reason: Attachment
Reply With Quote
  #2  
Old 12-10-2017, 06:36 PM
macropod's Avatar
macropod macropod is offline Chart Fit to Content Windows 7 64bit Chart Fit to Content Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

After inserting the charts, you could re-set the width of all of them in a single pass with a macro like:
Code:
Sub Demo()
Dim sWdth As Single, iShp As InlineShape
With ActiveDocument
  With .PageSetup
    sWdth = .PageWidth - .LeftMargin - .RightMargin - .Gutter
  End With
  For Each iShp In ActiveDocument.InlineShapes
  With iShp
    If .Type = wdInlineShapeChart Then .Width = sWdth
  End With
Next
End With
End Sub
For PC macro installation & usage instructions, see: http://www.gmayor.com/installing_macro.htm
For Mac macro installation & usage instructions, see: https://wordmvp.com/Mac/InstallMacro.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
chart

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
PPT 2010 - Animated Chart by Series - Animations reset when editing chart agaudet21 PowerPoint 0 10-12-2017 06:18 AM
Macro to save docx to doc that checks compatibility and converts content controls to static content. staicumihai Word VBA 4 10-12-2016 08:23 PM
Chart Fit to Content Excel found unreadable content in file.xls. Do you want to recover the content of this workbook? Sanfran Excel 2 10-21-2014 12:09 AM
Chart Fit to Content macro for change content of cell2 when content of cell1 changes Intruder Excel Programming 1 11-17-2012 08:24 PM
Package for CD with links to Windows media player content and Flash Shockwave content hectorh PowerPoint 4 10-15-2009 12:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:11 AM.


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