I have created 3 graphs with the same y and x axis and would like them to have the same size/format so i can add them in powerpoint and produce a tidy picture with them. How can i make them excactly the same? On the x axis i have years so i would like to put the graphs one after the other and have each year of each graph right undernaeth the respctive year.
Thank you
You can size the chart objects by selecting them whilst holding the SHIFT key.
This will select them as objects rather than charts. Right click and format object to adjust width and height.
Adjusting the plot area is more difficult as there is no alignment tools.
Code is probably the best thing.
Hi, if you're using Excel 2007 and want to specify a specific sized chart, simply click on a chart's border, then go to the format tab above the ribbon. To the far right you'll see a Height/Width box, which you can adjust to suit your needs.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks