| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 26452 | 2002-10-27 22:01:00 | Excel Chart Sizing | jeep (1673) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 93579 | 2002-10-27 22:01:00 | Is there any way of specifying the size of a graph created in Excel 97? I want to have two charts on the same worksheet of the same dimensions so it looks nice! Thanks in advance |
jeep (1673) | ||
| 93580 | 2002-10-27 22:26:00 | You should be able to resize by simply grabbing the corners of your chart and dragging. You can also drag the chart to a new location in the same way. |
Capt Jimbo (17) | ||
| 93581 | 2002-10-27 22:30:00 | Not quite sure what you mean, you can drag and size freely when the chart is in a worksheet. Or is this the problem? You dont know when they are the same size? Use the count of rows/columns to get them the same. If using Office XP it gives the % in each axis when you first drag the size. Once you stop it goes back to 100% starting next time, so you need to get it right first time. AFAIK there is no default size setting. |
godfather (25) | ||
| 93582 | 2002-10-27 22:37:00 | You can force the chart to "Snap" to the cell borders by holding down ALT while dragging. This may help to ensure they are exactly the same size. |
Capt Jimbo (17) | ||
| 93583 | 2002-10-27 22:39:00 | And if its a repetitive charting operation copy and paste the page, then change the source data settings. | godfather (25) | ||
| 1 | |||||