Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I change size of the picture without changing chartobject?
Hi there,
I have this code in a userform and get with it a picture in the same size as the chartobject - to small. I want a much larger (fill the screen as much as possible). I can easily solve it by changing size of the chartobject before export to gif, but i dno't want to do that. I want to change the size of the gif during or after importing it by LoadPicture. How? Help = Forever happy /Regards Dim ChartNum As Integer Private Sub UserForm_Initialize() Debug.Print "frmPPT initilize " ChartNum = 1 UpdateChart End Sub Private Sub UpdateChart() Set CurrentChart = Blad102.ChartObjects(ChartNum).Chart ' Save chart as GIF Fname = ThisWorkbook.Path & Application.PathSeparator & "temp.GIF" CurrentChart.Export Filename:=Fname, FilterName:="GIF" ' Show the chart Image1.Picture = LoadPicture(Fname) End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I change size of the picture without changing chartobject?
See answer in excel.charting group.
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Marie J-son wrote: Hi there, I have this code in a userform and get with it a picture in the same size as the chartobject - to small. I want a much larger (fill the screen as much as possible). I can easily solve it by changing size of the chartobject before export to gif, but i dno't want to do that. I want to change the size of the gif during or after importing it by LoadPicture. How? Help = Forever happy /Regards Dim ChartNum As Integer Private Sub UserForm_Initialize() Debug.Print "frmPPT initilize " ChartNum = 1 UpdateChart End Sub Private Sub UpdateChart() Set CurrentChart = Blad102.ChartObjects(ChartNum).Chart ' Save chart as GIF Fname = ThisWorkbook.Path & Application.PathSeparator & "temp.GIF" CurrentChart.Export Filename:=Fname, FilterName:="GIF" ' Show the chart Image1.Picture = LoadPicture(Fname) End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change cm to inches in Format Picture size | New Users to Excel | |||
Combo Box text and Controls changing size on Monitor change | Excel Worksheet Functions | |||
picture size can not change to web quality | Excel Discussion (Misc queries) | |||
How do I change default picture size | Excel Discussion (Misc queries) | |||
How can I change size of the picture without changing chartobject? | Charts and Charting in Excel |