View Full Version : Excel Chart Sizing

28-10-2002, 11:01 AM
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

Capt Jimbo
28-10-2002, 11:26 AM
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.

28-10-2002, 11:30 AM
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.

Capt Jimbo
28-10-2002, 11:37 AM
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.

28-10-2002, 11:39 AM
And if its a repetitive charting operation copy and paste the page, then change the source data settings.