Change graphic chart color bar based on name?

Phox

Well-known Member

Joined

Jul 26, 2004

Messages

522

• Jul 16, 2009

• #2

Yes. Exactly how depends on the details of your chart. My best guess is that you have all the data in one series when it should be two. Try this: Right click on chart and select Source Data. Where it says "Series in:" change from Columns to Rows, or vice versa.

 

Last edited: Jul 16, 2009

Upvote 0

J

Jimic

New Member

Joined

Jul 16, 2009

Messages

6

• Jul 16, 2009

• #3

Thank for your atention Phox.
I have all data in one series, i did what you said but it assings a diferent color to each category. I want just two colors, Intel and AMD.

 

Upvote 0

Phox

Well-known Member

Joined

Jul 26, 2004

Messages

522

• Jul 16, 2009

• #4

Can you try describing the layout of your data table?

 

Upvote 0

tusharm

MrExcel MVP

Joined

May 28, 2002

Messages

11,029

• Jul 16, 2009

• #5

The easiest way might be...well, depends on how many data points you have.

If just a few, change those that belong to one of the companies to the desired color. First click on the series to select it. Then, click on a data point. This will select the data point by itself. Right-click and select Format Data Point...and set the marker/fill color as desired. Repeat for each of the other data points.

If a lot, put the data for the 2 series in 2 columns and plot them as two series. Format the 2 series as desired.

Jimic said:

Thank for your atention Phox.
I have all data in one series, i did what you said but it assings a diferent color to each category. I want just two colors, Intel and AMD.

Click to expand...

 

Upvote 0

J

Jimic

New Member

Joined

Jul 16, 2009

Messages

6

• Jul 16, 2009

• #6

Just two collums. Processors and Speed Values.
For example:

Intel Core 2 - - -- - - 24
Intel Quad - - - - - - - 45
AMD Phenom - - - - - - 86
Intel Dual - -- - - - - - 104
AMD Opteron - - - - - - - 130

 

Upvote 0

J

Jimic

New Member

Joined

Jul 16, 2009

Messages

6

• Jul 16, 2009

• #7

I tried to do what tusharm said. One series for intel, other for AMD. It works for the colors, but the graphic is not what i wanted.
It display the less value from Intel and below the less value for AMD and so forth, one series and then the other one. I want the values to be decreasing, no matter what series is. Was i clear?
Thanks

 

Upvote 0

Z

Z51

Well-known Member

Joined

Dec 12, 2007

Messages

747

Office Version

1. 365
2. 2016

• Jul 16, 2009

• #8

Cross posted: http://www.excelforum.com/excel-charting/691799-change-color-bar-based-on-name.html#post2129140

 

Upvote 0

J

Jimic

New Member

Joined

Jul 16, 2009

Messages

6

• Jul 16, 2009

• #9

Sorry about the cross post guys, didn´t know that rule. Sorry.
I´ll stay here because you guys are helping me.
Thanks a lot.

 

Last edited: Jul 16, 2009

Upvote 0

Phox

Well-known Member

Joined

Jul 26, 2004

Messages

522

• Jul 16, 2009

• #10

Try this macro, you may need to change a couple things depending on how many charts there are, series, etc.

Code:

Sub ChangeBarColors()
    
    Dim i As Long
    Dim YLabels() As Variant
    
    With ActiveSheet.ChartObjects(1).Chart.SeriesCollection(1)
        YLabels = .XValues
        For i = LBound(YLabels) To UBound(YLabels)
            If Left(YLabels(i), 3) = "AMD" Then
                .Points(i).Interior.ColorIndex = 3
            Else
                .Points(i).Interior.ColorIndex = 5
            End If
        Next i
    End With
    
End Sub

 

Upvote 0