+ Reply to Thread
Results 1 to 4 of 4

Centering Data Range Captions.

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Centering Data Range Captions.

    I've attached my chart and data. My need is simple to visualize, but I don't know how to do it.

    In my data I have Year, for example 2019 to 2020.
    For each year, I have Type, for instance, Administration.
    Within each type I have various programs, and it's these values that are represented by the columns.

    For my bottom axis, my chart is currently repeating the Year range for each Type. What is want is each type, as I have, but the Year range to be centered across all the types extant for that year range. I have an example at the bottom of the worksheet attached.

    Thanks in advance for any help I receive.
    Attached Files Attached Files
    I know I'm not stupid, but I suspect I'm a lot stupider than I think I am

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Centering Data Range Captions.

    Hi there,

    Here's a cheap 'n' cheerful approach which might do what you need:



    Clear Cells A2:A10

    Insert the following formula in Cells B3, B6 and B9

    Please Login or Register  to view this content.

    Hope this helps.

    Regards,

    Greg M

  3. #3
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Re: Centering Data Range Captions.

    I'm so sorry. IT changed our email addresses, so I wasn't being contacted and forgot about this thread.

    Greg, it took me a minute to understand your solution, but very easy and works very well. Thank you so much!

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Centering Data Range Captions.

    Hi again,

    Many thanks for your feedback and also for the Reputation increase - much appreciated!

    You're welcome - glad I was able to help.

    Best regards,

    Greg M

+ 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] How to loop through data and display on userform using label captions
    By RoroBear in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-27-2020, 10:34 AM
  2. Centering Image in Merged Range
    By saq7792 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-15-2019, 07:10 PM
  3. [SOLVED] Help searching for a row, then label captions using row data
    By radabm in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-09-2017, 06:34 PM
  4. Centering data in one column between two adjacent rows
    By gallagt01 in forum Excel General
    Replies: 5
    Last Post: 04-18-2017, 11:12 AM
  5. Excel 2007 : Keyboard shortcut for centering data
    By DivaDiva in forum Excel General
    Replies: 1
    Last Post: 02-16-2012, 06:29 AM
  6. Centering image (horizontally) in Range
    By speedone in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-04-2011, 10:51 AM
  7. Row Captions AND Column Captions Possible?
    By (Pete Cresswell) in forum Excel General
    Replies: 1
    Last Post: 04-30-2005, 09:06 AM

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