Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another question about exporting charts
Hi All,
Andy helped me once with another related question: I have a new question: Situation: An existing Macro4 program. I want to make a picture of a chart which is positioned on a chart sheet (NOT a worksheet). Scaling is done via the program (set to A5 paper size). and the arguments are given by the Macro 4 program to a VBA function (works perfect). This is the working VBA code Sub ExportGraph(TargetFile As String, Filtr As String) On Error Resume Next ActiveChart.Export Filename:=TargetFile, Filtername:=Filtr End Sub QUESTION: I want to get rid of this white border around the graph (4 points or something) Can somebody tell me how I have to extend the above code for removal of this border? I saw something like this in a previous example but I don't know how I can get it to work: With .Chart.Shapes(1) .Placement = xlMove .Left = -4 .Top = -4 sngWidth = .Width sngHeight = .Height End With Many thanks in advance. Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
exporting charts | Charts and Charting in Excel | |||
Automatically resize excel charts when exporting them to PowerPoin | Charts and Charting in Excel | |||
Exporting Excel Charts in Separate Tabs | Excel Discussion (Misc queries) | |||
e-mailing or exporting charts as a .pdf or .tif format | Charts and Charting in Excel | |||
Exporting Charts as GIFs | Excel Programming |