MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Modifying Graphs


Posted by Andrew@Umass on December 31, 2001 6:07 AM

Hi:

We are working on making some graphs for a publication, and cannot figure out how to put the graph title at the bottom of the object.

In other words, we would like the title to be below the X axis label. Can this be done with Excel?

Also, is there a way to shrink the "white area" in the box that surrounds the graph, without also shrinking the size of the graph itself?

I hope that these questions make sense. We greatly appreciate any help, as the Excel Help has not answered our questions.

Thanks!


Posted by Dan on December 31, 2001 6:43 AM

After you create your chart you can select any object on that page and move or resize to your liking. For instance if you click on the title on the chart you'll notice that it will select the box around the text. You can click on the border of this box and move it to the bottom if you like. Same thing with the graph itself. You can move the graph around to any part of the page, or you can resize it by dragging the corners of the graph. Just like you would with most any object in Windows. HTH.