Colour Data Points On Chart From Dynamic Cell Colour?

Oct 3, 2012

I would like it to loop through all the charts on the "Graphs" sheet.

It works well but gives a "Run-time error '1004'" Application-defined or object-defined error afterward that I would like to get rid off.

Sub Colour_Chart_working()
Dim rngColors As Range
Dim rngCell As Range


View 1 Replies


Colour Chart Data Points

May 11, 2007

How do i conditionally colour chart data points. This is an example of my data from which the chart is created from.

Salesman A 10
Salesman B 10
US Total 20
Salesman C 20
Salesman D 10
Philipines Total 30

When the chart is created, i would like the country total data points to be in orange while the rest of the data points should remain in white. I tried this code and it returned me an error.

ActiveChart.SeriesCollection("Average of Margin").Points("ID Total").Select
With Selection.Interior
.ColorIndex = 36
.Pattern = xlSolid
End With

I also tried the online F1 help it told me to use Points(Index). However i do not want to refer to the ponint with an index as the number of salesman or country could change. Therefore changing the index points.

View 4 Replies View Related

VBA Code To Colour Certain Cells Based On RGB Colour Shown In Cell A1

Apr 17, 2014

I have a lookup that gives and RGB colour code in Cell A1; for example 186, 206, 140.

I'd then like Cells R10:V15 to fill with the RGB colour based on the result in A1.

View 2 Replies View Related

How To Make Arrange Colour Equal Cell Colour

May 23, 2014

A column of cells can be 1o different shades of green according to their value (achieved by using conditional formatting.) I want to arrange that at a certain time all the cells of a part of the row of a formatted cell are the same colour.

View 4 Replies View Related

Search Excel For Cells With Numbers Of Certain Colour And Changing Said Colour

Feb 13, 2014

Is it possible to search Excel by cell colour, i.e. font colour...and then change the said colour to another one?

View 3 Replies View Related

Bar Chart Colour

Oct 1, 2009

I have a problem relating to a bar chart that I just can't get around. I have Excel 2003. My problem is this. I have created an attendance record sheet for members of a club. The sheet records attendances for two separate events which occur a week apart every month. The names of the members are shown vertically in one column. Multiple parallel columns then follow in which members' attendances are recorded. At the top of the sheet, at the head of each attendance column, are two headings, one on top of the other. The first of these is the date, and the second is the attendance rate shown as a percentage. I can generate a bar chart alright from these two headings. My problem is that I want some way of showing the two different events every month as two different colours, event one in red and event two in blue, so that they will stand out. So far the chart will only let me show everything in one colour.

View 9 Replies View Related

How To Colour Different Bars In Bar Chart

Jan 20, 2014

I have a bar chart which compares two columns of data. the data in one column is fixed to 100. the data in the other column varies. a third column states whether each entry is "A" or "M". Is there a way to include the A or M on the bar chart? Perhaps by having a set colour whether the data is A or M?

View 1 Replies View Related

Colour 7 Cells In A Row And Then Switch Colour?

Jul 17, 2014

So I have a macro that colors the selected cells in a certain color. Now im looking for a code that will switch that color every 7th cell, the cells will only be selected horizontally. For example:

if the selected range is 10 cells, 7 of them should be in one color and 3 of the should be in another. But if the selected range is 15 cells the first 7 should have one color and the next 7 should have another and then the last one should have the first color again, and so on..

View 6 Replies View Related

Change Colour Of Chart Series

Jan 4, 2010

I'm attempting to write a code that will change the colour of a series in a chart based on the name of each series. i.e. I have Roads, Water and Rail as three of my series names. can i somehow assign the colours yellow, blue and red to these series using macro code.

View 5 Replies View Related

Change The Colour Of A Column On A Chart

Jul 28, 2006

I have created a column chart and am now trying to change the colour of one
of the bars. Here is the code I am using:

With chtChart
With Selection.Interior
.ColorIndex = 3
.Pattern = xlSolid
End With
End With

View 4 Replies View Related

Bar Chart Which Counts How Many Cells Are Formatted As A Colour

Feb 17, 2014

How do I write a bar chart which reads the format of a cell instead of the content? ie I want to count how many cells in each column are amber. Amber cells have already been decided by conditional formatting.

See demo attached : bar chart demo.xlsx‎

View 6 Replies View Related

Vba For Conditional Chart Fill Colour Change

Apr 22, 2014

I have a spread sheet with various tick boxes, that when ticked calculate an accumulative percentage in a cell. This cell is the basis of my graph. e.g. if the cell displays 80% - the chart with show 80% - simple.

however, I want to write a vba code that changes the fill colour of the chart depending on the percentage.

i.e. if the percentage data = 0-49% I wish the chart to display as red. 50-69% - yellow and 70%+ = green.

View 4 Replies View Related

Conditional Series Collection Colour For Chart

Sep 24, 2009

I am using a bar graph and would like conditional formatting for a series collection. So if the series collection is greater than 30%, the single entry (not the whole series) would turn red. I have attached an image of what I currently have. There is a data validation list at the top which tells the graph what series to use, so the data is always changing.

I hope this all makes sense. Basically, if an entry is above 30%, I want the single entry in the series to turn red.

View 2 Replies View Related

Dates With Different Colour In X Axis In Excel Chart?

May 12, 2013

I want to draw a chart in Excel, in X axis Dates and in Y axis some other data. The dates which fall Saturday and Sunday will show in RED colour. Other dates will show in default colour.

View 7 Replies View Related

Stacked Area Chart Series Colour Change

Jan 6, 2010

I have a stacked area chart located on its own individual worksheet. I would like to use VBA to apply colours to individual series based on the name of that series. I have applied the following code which I found on the following help forum, changing it slightly to fit my needs:

View 3 Replies View Related

Change Row Colour If Any Data Populated In Particular Cell?

Jun 26, 2013

I am looking to change a row colour if any type of data is entered into a specific cell.

Context: In column H entitled 'Start Date' when someone enters a date n any format into this box, I want the whole row to change colour to easily see what projects have started and what ones havent.

View 1 Replies View Related

Display Cell Data In Message Box Based On Colour

Apr 8, 2008

I wonder if the following is possible in the worksheet_open event. I want to be able to open my worksheet and see via a message box all the important features I need to look at.

Using column AG,
Take the cells that are conditionally formatted to red, take the corresponding cells in column A & B and output this
information in a message box.

View 9 Replies View Related

Color Chart Data Points By Cell Values Of Non-Source Data

Apr 14, 2008

I have a bar chart that was made from table 1 which has the value in it. I have another table, table 2 that has the name corresponding to the value in table 1. I want to color data points in a bar chart with a different color for each name I have in table 2. I also want to give a data label in the data points with the value I have in table 2 instead of the original data label from table 1. Is it possible to do it?

View 3 Replies View Related

Colour Rows With More Than One Colour

Nov 24, 2011

I'm creating a worksheet which tracks pupils progress in our school. down the left there is a column to put in the level they came into our school on - eg 1C or 3B etc.. to the right of the level is a colour coded row which shows Pink, Yellow and Green - if the pupil makes it into the green part of their level by the time they leave then they are on target.

Basically I have a column of cells which use a data validation list which is linked to another sheet with a list of levels. What I want to happen is when I select the level - it fills the row to the right with the correct colours.. I've attached a picture to show you what i'm trying to do.

Reason being is - we might have 6 kids on L3, and 1 on L1 so the number of rows needed for each level changes - at the moment I'm having to copy and paste - which although is easy enough, it is a bit tedious when you have a whole bunch of pupils to put on the grid.

I can't find the option in imageshack to use a thumbnail

View 6 Replies View Related

Changeing A Cells Colour Basing On Other Cells Colour

Mar 23, 2009

i want a cell to change to the colour green if 5 other cells on the page are green colour.

I want a cell to change colour to red if there are 1 or more red cells on the page.

How do I make this work?

View 8 Replies View Related

Chanage Autoshape Colour According To Autoshape Colour In Another Worksheet

Oct 23, 2008

I am trying to automatically change the colour of an oval in worksheet1 to the colour of oval3 in worksheet 2.

Currently oval3 (Worksheet 2) has the a vba code that changes its colour when you click on it.

View 9 Replies View Related

How To Group Data Using Colour

Mar 25, 2009

I have a spreadseet where I am pasting data which all the time change.

I would like to know if there is a way to highlight cells with same value with one colour, other same cells with second colour,3rd....10 colours would be enough i think....

Formula should work for at least 200 rows.
i.e. I have in column D Dates in 20 rows.
1-10 row are same (blue highlighted cells)
11-12 and 15 are same (yellow highlighted cells)
13-14 row are same (red highlighted cells)
16-20 row are same (red highlighted cells)

View 9 Replies View Related

Colour To A Cell

Mar 22, 2007

Below is a formula i am using on a spread sheet. What I would actually like to do is instead of the cell showing "OOS" if the statement is false, I would like it to show Z11 but in bold red so it stands out.


View 9 Replies View Related

How To Tell Cell To Get The Colour Of Itself

Jan 23, 2008

I am using

With Selection.Interior
.ColorIndex = 36
.Pattern = xlSolid
End With

This colours the cell that colour (36) how do I say to take the colour in the cell already?

View 9 Replies View Related

Colour Columns Based On Data

Apr 13, 2013

I have a sheet (calender month) with week number in the top row, date on the second and weekday on the thirdh.
Is there some code that will change the background colour of the entire column when the weekday say's sa or su (saturday/sunday)?

I could do it manually but every year the first of januari starts on a different day and I would like to automate it.

View 9 Replies View Related

Conditional Formatting - No Data No Colour

Nov 4, 2008

On this particular formula but my colleagues have informed me that they require cells with no dates in to have no colour fill. Firstly, I have searched and tried myself with no success on stopping the below formulas from filling empty cells with red, they are as below;

Code below for 11 months after entered date:

View 2 Replies View Related

Conditional Formatting - Colour A Whole Row Of Data

Jun 8, 2009

I am trying to colour a whole row of data (in columns A through to AA) based on the numeric entry in column AB. The numeric entry is either 1, 2 or 3. I reckoned I needed to use the IF function, but as writing formula is not my strong point I am struggling to enter the correct data! The first row of data I wish to use is 3. I have tried the following but to no avail: =IF($AB3,1). =IF($AB3=1). =IF($AB3="1").

View 5 Replies View Related

Sort Data In Rows By Colour

Aug 13, 2012

I have a big database, each row is having it's colour. How can I sort by colour? I mean, data with one colour comes first, then data with another colour comes after etc.

View 1 Replies View Related

Cell Colour Purple

Dec 19, 2009

I have a worksheet with columns formatted to total in RED if negative & BLACK if positive. However, despite redoing time & time again, although the total is positive, the colour of the text is PURPLE? All surrounding cells are formatted correctly. Why cant I get rid of this PURPLE?

View 6 Replies View Related

VBA Cell Colour Based On The Value

Sep 24, 2009

I have a userform that outputs data to a worksheet. One of the textboxes contains either one of 3 values, either: N/A, Debit, or Credit. This textbox is called "tbDebitOrCredit".

What I need is, when the the user clicks the "Submit" button and the data is output to the worksheet, the cell that recevies it output from "tbDebitOrCredit" turns a specific colour based on the value.

For example:

N/A = White
Debit = Red
Credit = Green

View 2 Replies View Related

Copyrights 2005-15, All rights reserved