+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Forum Guru zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    Excel 2007
    Posts
    5,740

    how to chose single color in design?

    Attachment 38308

    This is a screen shot...
    I can choose design of above (sample is purple) but all of them are in range of very dark purple to very light purple and as you can see in red circle - light lines are very hard to see...

    How I can choose a simple, solid, old-fashin black color for all lines

    (Can take one by one and change them but there is hundreds lines and adding new... other words, I want to change all at once...)
    Last edited by zbor; 03-27-2009 at 05:50 AM.
    "Relax. What is mind? No matter. What is matter? Never mind!"

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,944

    Re: how to chose single color in design?

    You can not apply formatting to all lines at once. Code is the only quick way.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Guru zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    Excel 2007
    Posts
    5,740

    Re: how to chose single color in design?

    Hm, that's not solacing

    Look on excel table (you have on sent items, too big to post it here)... I somehow manage to do that on first sheet (don't ask me how.. I think I mess something with a code )

    But strange that you can't pick single color for entire chart...
    "Relax. What is mind? No matter. What is matter? Never mind!"

Thread Information

Users Browsing this Thread

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

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.2.0