If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart size
Is there a way to make the User defined chart be made a specific size when
created? We will be making multiple charts and I wish them all to be a specific size as they are then copied to Word. Thank you |
#2
|
|||
|
|||
Chart size
Deborah -
If you make the chart with the Chart Wizard, you are stuck with the default size and position, which is *approximately* half of the height and width of the active pane, centered within the pane. You can resize charts by dragging their corners, and if you hold down the Alt key, the chart edges stay aligned with cell boundaries, so you could make the charts the same size this way. If you want to use VBA, my Quick Chart VBA page has some hints: http://www.geocities.com/jonpeltier/...kChartVBA.html For example, use the ChartObjects.Add method do add charts to the active sheet. You specify the size and position explicitly. If you're using VBA, you may as well code the copy-paste operations as well. I have more hints here, mostly with PowerPoint, but also some rudimentary Word examples: Using Excel with Other Office Applications http://www.geocities.com/jonpeltier/Excel/XL_PPT.html - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Deborah Mowry wrote: Is there a way to make the User defined chart be made a specific size when created? We will be making multiple charts and I wish them all to be a specific size as they are then copied to Word. Thank you |
Thread Tools | |
Display Modes | |
|
|