+ Reply to Thread
Results 1 to 2 of 2

Resizing Bar Chart Axis Titles

Hybrid View

  1. #1
    Registered User
    Join Date
    06-09-2015
    Location
    Washignton, DC
    MS-Off Ver
    2013
    Posts
    1

    Resizing Bar Chart Axis Titles

    I would like to shrink the size of my axis labels. Specifically, shrink it horizontally, and make labels "wrap". I'd then like the actual chart to take up more of the area. Unfortunately, I can't do this. Excel seems to have locked the ratio between the two. How can I fix this?
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Resizing Bar Chart Axis Titles

    From what I can find, it looks like the bar chart is stuck using about 50/50 when you have long labels. You can make the chart skinnier, but it will keep about half the area filled with the text and half with the graph. I did find that if you switch it to a column chart instead, the words may not take up as much room.

    Sorry that isn't much help.
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How do you add axis labels and titles to a Chart via VBA?
    By bananajelly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-28-2014, 06:00 PM
  2. Chart axis resizing affecting full screen
    By msixdatateam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-27-2014, 09:14 AM
  3. Formulas in Chart Titles & Axis Titles
    By Bobbbo in forum Excel General
    Replies: 1
    Last Post: 05-20-2010, 02:02 PM
  4. I have problem with chart titles Value 'Y' Axis
    By Ramesh Babu in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-03-2006, 08:35 AM
  5. chart axis Titles
    By seedbankstudy in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-05-2005, 01:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1