Creating a Chart based on Cell color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to create a chart based on different colors of each row
I have about 250 rows of data and each row has a different fill color that resembles something. So now I want to make a Chart that can tell me how many of each color there is. Can anyone help?
 
Ashley said:
Is it possible to create a chart based on different colors of each row?
I have about 250 rows of data and each row has a different fill color that
Click to expand...
resembles something. So now I want to make a Chart that can tell me how many
of each color there is. Can anyone help?

This code

Cell.Value = Cell.Offset(0, -1).Interior.ColorIndex

returns the color index # of the cell immediately left of the active cell.
If you can find an appropriate range to select, you could use

For Each Cell In Selection
Cell.Value = Cell.Offset(0, -1).Interior.ColorIndex
Next

HTH,
Andy
 
Back
Top