Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Saving chart as picture - how to maintain the same size of the fil
Hi,
when I copy a chart and paste it as a picture in any photoprogram (Paint Shop Pro or PhotoShop) I get a different size of the file if I use different computers, screen sizes or photo programs. I need to get the same size everytime, 640 pixels wide. Does anyone know how to do it? Im "willing" to use only one photo program if that solve the problem, but do I have to use the same computer everytime with the same screen everytime? In Paint shop Pro I can resize the picture and maintain the ratio, but it still doesnt help me as the text in the chart gets desformed. regards Martin |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Saving chart as picture - how to maintain the same size of the fil
You could use VBA to export the chart directly to a picture, and it will
give you consistent dimensions. The command is like this: ActiveChart.Export PathAndFileName, Filter I recommend PNG or GIF for the filter. If you're not comfortable with VBA, John Walkenbach's free Chart Tools utility (http://j-walk.com) will export the chart for you. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Martin" wrote in message ... Hi, when I copy a chart and paste it as a picture in any photoprogram (Paint Shop Pro or PhotoShop) I get a different size of the file if I use different computers, screen sizes or photo programs. I need to get the same size everytime, 640 pixels wide. Does anyone know how to do it? Im "willing" to use only one photo program if that solve the problem, but do I have to use the same computer everytime with the same screen everytime? In Paint shop Pro I can resize the picture and maintain the ratio, but it still doesnt help me as the text in the chart gets desformed. regards Martin |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Saving chart as picture - how to maintain the same size of the
Thanks Jon! It was the answer of my question. I also found this help how to
make a VBA module - exporting charts to pictures. http://www.vbaexpress.com/kb/getarticle.php?kb_id=449 However it still didnt help my all the way as the chart also got other "layers" of a rectangle, a text box and a figure. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Saving chart as picture - how to maintain the same size of the
If you add the embellishments to the chart not to the worksheet, they will
export with the chart. Select the chart prior to clicking on the button for the specific drawing tool, then add the object. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Martin" wrote in message ... Thanks Jon! It was the answer of my question. I also found this help how to make a VBA module - exporting charts to pictures. http://www.vbaexpress.com/kb/getarticle.php?kb_id=449 However it still didnt help my all the way as the chart also got other "layers" of a rectangle, a text box and a figure. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintain formatting in linked chart title | Charts and Charting in Excel | |||
Maintain the Excel chart size after pasting into Word | Excel Discussion (Misc queries) | |||
Set the size of a background picture in Excel | Excel Discussion (Misc queries) | |||
How do I change default picture size | Excel Discussion (Misc queries) | |||
jpeg picture always the same size | Excel Worksheet Functions |