none
Excel: Generate bubble chart and color the bubbles background wiht cell background color RRS feed

  • Question

  • Hello,

    can't found out how to color a background color of a bubble in a bubble chart with a backgound of a cell.

    so I got the cell and I got the Series object. I tried it over:

    SeriesCollection(1).Fill.BackColor.RGB = Cells(1, 1).Interior.RGB

    does not work, then over

    SeriesCollection(x).Format.Fill.BackColor.RGB = Cells(headerOffset, 1).Interior.Color

    does not work...

    please help.

    Wednesday, June 24, 2015 9:57 AM

Answers

  • Try using ForeColor instead of BackColor:

    ActiveSheet.ChartObjects(1).Chart.SeriesCollection(1).Format.Fill.ForeColor.RGB = Cells(1, 1).Interior.Color

    Or:

    With ActiveSheet.ChartObjects(1).Chart.SeriesCollection(1).Format.Fill
        .Visible = msoTrue
        .ForeColor.RGB = Cells(1, 1).Interior.Color
        .Transparency = 0
        .Solid
    End With


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Wednesday, June 24, 2015 1:58 PM

All replies

  • Try using ForeColor instead of BackColor:

    ActiveSheet.ChartObjects(1).Chart.SeriesCollection(1).Format.Fill.ForeColor.RGB = Cells(1, 1).Interior.Color

    Or:

    With ActiveSheet.ChartObjects(1).Chart.SeriesCollection(1).Format.Fill
        .Visible = msoTrue
        .ForeColor.RGB = Cells(1, 1).Interior.Color
        .Transparency = 0
        .Solid
    End With


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Wednesday, June 24, 2015 1:58 PM
  • Re: color chart series

    This is worth a try...
    ...SeriesCollection(1).Interior.Color = Cells(1, 1).Interior.Color
      '---
    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2 (Dropbox)
    (free & commercial excel add-ins & workbooks)

    • Edited by James Cone Sunday, October 30, 2016 6:53 PM
    Wednesday, June 24, 2015 2:17 PM