The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Excel 2007 Black and White Pattern Fills

    Discussion in 'Windows OS and Software' started by SerratedAuto, Feb 7, 2010.

  1. SerratedAuto

    SerratedAuto Notebook Consultant

    Reputations:
    35
    Messages:
    155
    Likes Received:
    1
    Trophy Points:
    30
    I am currently working on a publication for a journal, and one of the requirements that it has is that the charts should be black and white. I am using Excel 2007 to assemble the charts (that was probably mistake #1). One of the problems that I am having is that I have a few bar graphs with around 15-20 series, and when I tell Excel to make it black and white it uses these god awful gray scale colors that make it impossible to distinguish between the data sets.

    I remember in Office 2003 that the user had the ability to use Pattern Fills for the bar graphs. I've been looking for this feature in 2007, but can't seem to find it. Does anybody know if Office 2007 still supports this, and if not, can anybody recommend a third party solution to use pattern fills in Excel? Thanks!
     
    SerratedAuto, Feb 7, 2010
    #1
  2. wave

    wave Notebook Virtuoso

    Reputations:
    813
    Messages:
    2,563
    Likes Received:
    0
    Trophy Points:
    55
    wave, Feb 8, 2010
    #2