+ Reply to Thread
Results 1 to 4 of 4

Help on making a chart with cells no value but fill color only -

  1. #1
    Registered User
    Join Date
    07-27-2011
    Location
    doha, qatar
    MS-Off Ver
    Excel 2002
    Posts
    10

    Help on making a chart with cells no value but fill color only -

    Hi, my data in excel has no values, but are color coded (fill color), my question is how am I able to chart it. Here's the scenario. I have four rows, Green, Yellow, Red and Black, columns are each day of the calendar. Each color has a meaning, so I want to graph it (line graph probably) that will show the trend on a daily basis. Thanks. I have tried line graphs with no success or am I doing it wrong........

  2. #2
    Registered User
    Join Date
    07-27-2011
    Location
    doha, qatar
    MS-Off Ver
    Excel 2002
    Posts
    10

    Re: Help on making a chart with cells no value but fill color only -

    I'm using excel 2002 by the way.

  3. #3
    Registered User
    Join Date
    07-27-2011
    Location
    doha, qatar
    MS-Off Ver
    Excel 2002
    Posts
    10

    Re: Help on making a chart with cells no value but fill color only -

    Here's the file.

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

    Re: Help on making a chart with cells no value but fill color only -

    You will need to put numbers in the cells that have colour in order to chart them.

    You can use CF to colour the cells. Assign a value to each colour
    Green=4
    Yellow=3
    Red=2
    Black=1

    You can get conditional formatting to automatically apply, well actuall remove, colour from the cells.
    So for the Red row, once the values are applied, set the fill colour to red. The apply Conditional formatting setting the fill to no colour for values not equal to 2.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

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.6.0 RC 1