Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sizing charts uniformly {need some tricks here}
With a number of worksheets with similar charts, I need to clip out the charts basically all the same size for PowerPoint. Would like to size them to the nearest 5-pix both height and width but none of the methods are working. My worksheets are viewed at 70% and the charts are formatted to produce a professional appearance with small scale fonts, etc. Any tips for doing this? Have tried making the charts separate sheets but the fonts get all messed up. Even tried `sizerŽ utilities but none display or read out the chart boarder dimensions in pixels. -G |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sizing charts uniformly {need some tricks here}
Your life will be easier if you use a 100% view in Excel, and make the
charts the size you want them to be in PowerPoint. If you shift-click on a chart, so it is selected with white handles, not black, around its periphery, the Format Object menu item will format the chart like a shape, and you can get its dimensions in the dialog. I couldn't see in a ten second look how to change the units. I have a utility that shows you the size of the active chart: http://peltiertech.com/Excel/Charts/...ml#ChtSizeMenu and another that aligns and sizes multiple charts to match each other: http://peltiertech.com/Excel/Charts/...l#AlignChtDims - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... With a number of worksheets with similar charts, I need to clip out the charts basically all the same size for PowerPoint. Would like to size them to the nearest 5-pix both height and width but none of the methods are working. My worksheets are viewed at 70% and the charts are formatted to produce a professional appearance with small scale fonts, etc. Any tips for doing this? Have tried making the charts separate sheets but the fonts get all messed up. Even tried `sizerŽ utilities but none display or read out the chart boarder dimensions in pixels. -G |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sizing charts uniformly {need some tricks here}
On Mon, 28 Apr 2008 20:39:42 -0400, "Jon Peltier"
brought the following to our attention: Your life will be easier if you use a 100% view in Excel, and make the charts the size you want them to be in PowerPoint. If you shift-click on a chart, so it is selected with white handles, not black, around its periphery, the Format Object menu item will format the chart like a shape, and you can get its dimensions in the dialog. I couldn't see in a ten second look how to change the units. I have a utility that shows you the size of the active chart: http://peltiertech.com/Excel/Charts/...ml#ChtSizeMenu and another that aligns and sizes multiple charts to match each other: http://peltiertech.com/Excel/Charts/...l#AlignChtDims - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com Thanks.. great stuff!! -G wrote in message With a number of worksheets with similar charts, I need to clip out the charts basically all the same size for PowerPoint. Would like to size them to the nearest 5-pix both height and width but none of the methods are working. My worksheets are viewed at 70% and the charts are formatted to produce a professional appearance with small scale fonts, etc. Any tips for doing this? Have tried making the charts separate sheets but the fonts get all messed up. Even tried `sizerŽ utilities but none display or read out the chart boarder dimensions in pixels. -G |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
plot sizing within charts
Any suggestions for uniformly sizing the plot size within charts as well as the locations of text boxes and legends within the chart?
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sizing charts uniformly {need some tricks here}
On Mon, 28 Apr 2008 20:39:42 -0400, "Jon Peltier"
brought the following to our attention: Your life will be easier if you use a 100% view in Excel, and make the charts the size you want them to be in PowerPoint. If you shift-click on a chart, so it is selected with white handles, not black, around its periphery, the Format Object menu item will format the chart like a shape, and you can get its dimensions in the dialog. - Jon The above method worked but I had trouble since my worksheets are viewed at 65% to 70% and it was difficult to get the charts to look right in PPT. I tried going to 100% view but that would mean changing all the formats on scores of charts, which there was no time to do. Using 100% the charts no longer looked professional, more like `kiddieŽ quality. I wish that Microsoft could add some usability to this stuff. My preferred way is still to format the charts and them clip them out with PSP capture, then clean up the edges with a white brush tool. Finally reduce pallet to 16-colors and save as GIF. -G |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sizing charts uniformly {need some tricks here}
The above method worked but I had trouble since my worksheets are
viewed at 65% to 70% That's unfortunate. What do you feel are the particular unprofessional aspects of charts viewed at 100%? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... On Mon, 28 Apr 2008 20:39:42 -0400, "Jon Peltier" brought the following to our attention: Your life will be easier if you use a 100% view in Excel, and make the charts the size you want them to be in PowerPoint. If you shift-click on a chart, so it is selected with white handles, not black, around its periphery, the Format Object menu item will format the chart like a shape, and you can get its dimensions in the dialog. - Jon The above method worked but I had trouble since my worksheets are viewed at 65% to 70% and it was difficult to get the charts to look right in PPT. I tried going to 100% view but that would mean changing all the formats on scores of charts, which there was no time to do. Using 100% the charts no longer looked professional, more like `kiddieŽ quality. I wish that Microsoft could add some usability to this stuff. My preferred way is still to format the charts and them clip them out with PSP capture, then clean up the edges with a white brush tool. Finally reduce pallet to 16-colors and save as GIF. -G |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sizing charts uniformly {need some tricks here}
On Tue, 29 Apr 2008 21:16:16 -0400, "Jon Peltier"
brought the following to our attention: The above method worked but I had trouble since my worksheets are viewed at 65% to 70% That's unfortunate. What do you feel are the particular unprofessional aspects of charts viewed at 100%? - Jon To be fair, I'll try it aGaiN today while in the process of putting together our presentation. Generally with 100% views the fonts don't look small enough, such as would be seen in a app note or technical book. Also.. I've been working in 60% and 70% worksheet views for so long that going to 100% is like setting monitor/display resolution back to 800 x 600. :))) BTW.. thanks for the great tips and code. -G |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sizing charts uniformly {need some tricks here}
If you adjust all of the features of the worksheet at 100% to look as they
did when your zoom was at some smaller percentage, you should be most of the way to a suitable interface. Change font sizes, row heights, column widths, etc. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... On Tue, 29 Apr 2008 21:16:16 -0400, "Jon Peltier" brought the following to our attention: The above method worked but I had trouble since my worksheets are viewed at 65% to 70% That's unfortunate. What do you feel are the particular unprofessional aspects of charts viewed at 100%? - Jon To be fair, I'll try it aGaiN today while in the process of putting together our presentation. Generally with 100% views the fonts don't look small enough, such as would be seen in a app note or technical book. Also.. I've been working in 60% and 70% worksheet views for so long that going to 100% is like setting monitor/display resolution back to 800 x 600. :))) BTW.. thanks for the great tips and code. -G |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I uniformly scale all worksheets at once in page set-up in on. | Setting up and Configuration of Excel | |||
Sizing Excel charts | Charts and Charting in Excel | |||
Sizing individual charts with a macro | Charts and Charting in Excel | |||
Sizing charts | Excel Discussion (Misc queries) | |||
Calculating Differences Uniformly | Excel Worksheet Functions |