Creating a Chart based on Cell color

A

Ashley

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?
 
A

Andy Brown

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Function for summing or counting cells based on a specified fill color 3
Embed the same Excel multiple times 0
Bar Chart with Data Elements 1
Need Help with a VBA subroutine 0
Conditional Formatting based on cell text 3
How to filter rows data based on background color of individual cells 3

Top