+ Reply to Thread
Results 1 to 4 of 4

Make donut graph remain same size regardless of chart title size?

  1. #1
    Forum Contributor
    Join Date
    05-12-2014
    MS-Off Ver
    Excel 2013
    Posts
    131

    Make donut graph remain same size regardless of chart title size?

    Hey folks!

    I have a little problem that I can't quite figure out. It's pretty basic:

    I have a bunch of pie charts on a sheet. I want them to all be uniform in appearance, however if the Chart Title for a given chart is too short, the pie chart (donut in this case) increases in size to compensate for the smaller Chart Title. I don't want it to do this. I'd like the actual chart portion to remain the same size, even if the Chart Title is short, long, or not even present.

    Is there a way to do this? Attached is an image example of what I mean. Left chart has a long title and the donut chart is the size I like/want. Right chart has a short title, and the donut chart has increased in size as a result.

    Open to any suggestions!
    Attached Images Attached Images

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Make donut graph remain same size regardless of chart title size?

    Select the chart title. You should see 3 icons to the right of the chart, press the + sign.
    The pop out list should include Chart Title, within this are the options "Above Chart" and "Centered Overlay"

    The Centered Overlay will not resize the donut when the title text lenght varies. You will need to manually adjust the plot area so there is room for lengthy text.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    05-12-2014
    MS-Off Ver
    Excel 2013
    Posts
    131

    Re: Make donut graph remain same size regardless of chart title size?

    Quote Originally Posted by Andy Pope View Post
    Select the chart title. You should see 3 icons to the right of the chart, press the + sign.
    The pop out list should include Chart Title, within this are the options "Above Chart" and "Centered Overlay"

    The Centered Overlay will not resize the donut when the title text lenght varies. You will need to manually adjust the plot area so there is room for lengthy text.
    Heya, thanks for that tip. That works in not re-sizing the chart, but now I can't get the charts to size uniformly. The charts on each graph are slightly different sizes if I try to eyeball it. Is there a way to set the chart diameter or total size or something so that all the charts are the same size? And is there a way to make the chart adjust all at once? It makes me adjust in sections which results in parts of the chart being out of the circle. Picture attached for that part to show what I mean.

    Any help is appreciated!
    Attached Images Attached Images

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Make donut graph remain same size regardless of chart title size?

    You can not select multiple charts and adjust chart elements all at once.

    Your picture suggests you managed to select a series from the chart and drag it, which causes the Donut explosion effect.
    You move all of the donut at once select the plot area.

    Simplest way to get uniform charts, without resorting to VBA, Format 1 chart and the cut/paste as required and adjust data sources.

    Or format chart, Right click and save as Template.
    select another chart and Change chart type to use newly save template.
    Last edited by Andy Pope; 11-07-2019 at 04:14 AM.

+ 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. [SOLVED] Steering Wheel Chart Data Label Size. How do I change the size?
    By PhilHP in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-16-2018, 08:56 PM
  2. [SOLVED] Can I make a graph to be a specific size? (actual graph)
    By Jessica in forum Excel General
    Replies: 1
    Last Post: 11-17-2015, 10:43 AM
  3. how to make a Donut Chart
    By mushman1 in forum Excel General
    Replies: 4
    Last Post: 06-22-2010, 04:54 PM
  4. Font Size in Chart Title
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2006, 11:10 AM
  5. [SOLVED] axis title text box is wrong size in chart for excel 2003
    By hey_scott in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-15-2006, 08:30 PM
  6. Title Block in Excel Chart - Size problem
    By Stuart Saich in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-25-2005, 07:05 AM
  7. Adjusting size of graph title box
    By ayl322 in forum Excel General
    Replies: 1
    Last Post: 02-28-2005, 05:54 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