Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I resize a chart in Excel after the chart has been saved...
I am using Excel 2002 and trying to make a number of charts. I would like to
put two charts on each page - one on top of the other. I can't figure out how to make the charts smaller or how to import them to a single page. |
#2
|
|||
|
|||
Diana -
Rather than making separate chart sheets for each chart, put the charts onto a worksheet. In the last step of the chart wizard, choose the As Object In option, and choose a sheet from the dropdown list. For an existing chart, make the same choice after selecting Location from the Chart menu. You can easily size the charts in a worksheet if you remember this trick. When you move or size the chart, hold down the Alt key, and the edges of the chart will line up with the cell boundaries. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ DianaQ wrote: I am using Excel 2002 and trying to make a number of charts. I would like to put two charts on each page - one on top of the other. I can't figure out how to make the charts smaller or how to import them to a single page. |
#3
|
|||
|
|||
Thanks so much Jon for your reply. I did manage to find out today at work
how to do just what you said. I didn't know about the Alt move tho and will certainly use that on my next set of charts. Thanks again. "Jon Peltier" wrote: Diana - Rather than making separate chart sheets for each chart, put the charts onto a worksheet. In the last step of the chart wizard, choose the As Object In option, and choose a sheet from the dropdown list. For an existing chart, make the same choice after selecting Location from the Chart menu. You can easily size the charts in a worksheet if you remember this trick. When you move or size the chart, hold down the Alt key, and the edges of the chart will line up with the cell boundaries. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ DianaQ wrote: I am using Excel 2002 and trying to make a number of charts. I would like to put two charts on each page - one on top of the other. I can't figure out how to make the charts smaller or how to import them to a single page. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert a marker on an Excel bar chart? | Charts and Charting in Excel | |||
Lines not visible in an Excel line chart | Charts and Charting in Excel | |||
How do I set up a Levy-Jennings chart in Excel? | Charts and Charting in Excel | |||
excel chart size using inside positioning | Charts and Charting in Excel | |||
How do I break the value (Y) axis in an Excel chart ?? | Charts and Charting in Excel |