Re: Another question about exporting charts

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Eric Desart (afbox-_at_belgacom.net)
Date: 05/10/04 

Date: Mon, 10 May 2004 12:25:02 +0200

Please?
If it isn't possible, that's a usefull answer too.

Best regards
Eric

"Eric Desart" <afbox-@belgacom.net> wrote in message
news:OtFk9LgNEHA.1916@TK2MSFTNGP11.phx.gbl...
> Hi All,
>
> In order to prevent confusion. The reference to the Macro4 program is not
> related to the question in itself.
> I'm just looking to the completion of the VBA code to get rid of this
> border, export the picture and resore this border.
> The difference what the standard is that is on a graph sheet not on a
> worksheet, so I assume the chart holder does excist already.
> I hope I'm asking in the correct group.
> I remembered too late that there is a charting group too, but don't want
to
> cross post.
>
> With kind regards
> TIA
>
> Eric
>
> "Eric Desart" <afbox-@belgacom.net> wrote in message
> news:OWtBEyZNEHA.740@TK2MSFTNGP12.phx.gbl...
> > 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
> >
> >
>
>

Relevant Pages

  • Re: Another question about exporting charts
    ... The reference to the Macro4 program is not ... I'm just looking to the completion of the VBA code to get rid of this ... border, export the picture and resore this border. ... so I assume the chart holder does excist already. ...
    (microsoft.public.excel.programming)
  • RE: Charting data points and show a target range on the same chart
    ... and easier method is to use a stacked area chart. ... >> Regards, ... >> John Mansfield ... In the Format Data Series dialog box, ...
    (microsoft.public.excel.charting)
  • Re: Dynamic Charting Question
    ... >> Regards, ... >> Tushar Mehta ... >> Excel, PowerPoint, and VBA add-ins, tutorials ... >>> I'm attempting to set up a dynamic chart. ...
    (microsoft.public.excel.charting)
  • Re: Context-sensitive custom menu item.
    ... Regards, ... > desired, i.e., only enabled while in a chart, and then assign your own ... > You might be able to do something with the SelectionChange event, e.g., if ... >> Thanks Doug ...
    (microsoft.public.excel.programming)
  • Re: Custom Colors for Pivot Tables and Charts
    ... Listing 3.33 chLine Properties Usage Color Returns a chColor object. ... > Best Regards, ... >> The Microsoft Office Web Components Black Book with .NET ... >>> chart or a pivot table, instead of manually plotting the RGB's. ...
    (microsoft.public.office.developer.web.components)