Lessen the space above the plotted area

Above the plotted area is the Title of the graph.
I can drag the title closer to the plotted area but the area above the plotted area remains the same.
I am looking to build a dashboard type page (wihtout the use of the camera tool), so I want to minimize the area above the plotted area without minimizing the size of the chart.

Thanks,
JP
easycapitalAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

you can re-size the Plot Area. Select the plot area and drag the sizing handles. See screenshot.

cheers, teylyn
4-10-2011-11-27-46-p.m..png
0
 
easycapitalAuthor Commented:
Hello Teylyn,
Are you able to eliminate completely the white area above te grid lines - where the title of the chart lays.
Thanks!
Jp
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
No, you can't go up all the way. There will always be a small space left. You can further reduce that space if you don't have any Y Axis labels. See image
5-10-2011-7-56-05-a.m..png
0
 
easycapitalAuthor Commented:
Thank Teylyn.
I kept resizing the chart itself and then everything resized proportionally, but the trick as you mention is to resize only the plotted section.
JP
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.