Closed Thread
Results 1 to 3 of 3

I Need Help With Colors And Where I Would Like My Columns To Go(Underneath TheirHeadings)

  1. #1
    Registered User
    Join Date
    05-29-2013
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    I Need Help With Colors And Where I Would Like My Columns To Go(Underneath TheirHeadings)

    Hi,

    I am looking for a solution to the following questions.

    1) How do I get the three (3) items columns to be right underneath the ''Recovery Turnaround Days of Files Per Cheque'' heading

    2) How do I get each of items #1 - 3 column, to have each their own color (that is not the same color as the '' Average Recovery Days '' column color) ie;

    Item #1, 30 = I would like it to be say, Red
    Item #2, 35 = I would like it to be say, Pink
    Item #3, 30 = I would like it to be say, Yellow

    3) How do I get the column under the ''Average Recovery Days'' heading to have it's own color scheme as well, such as as say the color ''Purple'' (or any other color that is different from all the other 3 columns).

    If you could please let me know how you go about putting the columns so they align right underneath the particular heading, that would be awesome. Also, how to have a color scheme for the ''Average Recovery Days'' to have it's own color (For the column under this heading to have it's own color, what ever color that is), that does not match any of the column colors in items #1 - 3 (under the heading ''Recovery Turnaround Days of Files Per Cheque''),? I would appreciate it. I've also attached an excel document (NOTE: Please refer to sheet 3 (2) ), and an attachment of instructions and drawings of what I've described in this thread.

    Your response is much appreciated

    thank you kindly
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: I Need Help With Colors And Where I Would Like My Columns To Go(Underneath TheirHeadin

    1) How do I get the three (3) items columns to be right underneath the ''Recovery Turnaround Days of Files Per Cheque'' heading
    I'll assume just resizing and moving the graph is not an option. If you right click on the x-axis and choose 'Format Axis...' there are some values you can change, but I don't think they provide the amount of control you are looking for. Excel does not let you micromanage the placement of each column in the graph; however, if you wish to do this I believe your best bet is to create some 'empty' data columns to graph on the right so that it pushes all of your other columns to the left. This implies you will need to copy your data to another section and then graph this new section which includes the empty data (i.e. blank text and 0 for numbers).

    2) How do I get each of items #1 - 3 column, to have each their own color (that is not the same color as the '' Average Recovery Days '' column color)
    Click on the data series you want to change - it should highlight all of the columns of the same color. Now click again on just one of the highlighted columns - it should now be the only column highlighted. Right click on it and choose 'Format Data Point...' and then choose your color fill.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

  3. #3
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: I Need Help With Colors And Where I Would Like My Columns To Go(Underneath TheirHeadin

    Pls take some minutes to read forum rules, because:

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Alternate colors on stacked columns plot
    By adamNBU in forum Excel General
    Replies: 1
    Last Post: 02-19-2014, 01:27 PM
  2. [SOLVED] Highlight duplicate numbers with different colors in two columns
    By 17_types in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-28-2013, 04:05 AM
  3. VBA Halp! Sort Columns by date; Insert/add Data Underneath the Cell in Column B
    By goradiar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-06-2012, 09:10 AM
  4. Replies: 3
    Last Post: 05-19-2006, 12:40 AM
  5. Colors of columns after sorting data in the supporting table
    By Booger_Boy in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-24-2005, 12:06 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