[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

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
0
easycapital
Asked:
easycapital
  • 2
  • 2
2 Solutions
 
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

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now