Colouring Chart backgrounds

[Amanda]

Hello,

I would like to colour the background of a chart with 3
different horizontal stripes of colour. I have tried
drawing 3 rectangles on it but cannot send it to the back,
therefore it covers my actual chart info.

Is there a way of doing this?

Many thanks,

Amanda

 

[Andy Pope]

Hi Amanda,

Take a look at Jon Peltier's example, you should be able to adapt it.
(http://www.geocities.com/jonpeltier/Excel/Charts/ColoredQuadrantBackground.html)

Hello,

I would like to colour the background of a chart with 3
different horizontal stripes of colour. I have tried
drawing 3 rectangles on it but cannot send it to the back,
therefore it covers my actual chart info.

Is there a way of doing this?

Many thanks,

Amanda

--

Cheers
Andy

http://www.andypope.info

 

[Amanda]

Thanks Andy - I have just played around with that, however
I need to do it with a Bubble Graph and whilest it will
work for a scatter graph, it doesn't seem to want to with
a Bubble graph...

 

[Andy Pope]

Hi Amanda,

Ah yes, the bubble graph does not like to be combined with the others

Have a look at this previous post.
(http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&safe=off&threadm=ugnhQKWiCHA.1544@tkmsftngp09)

The choice of approach really depends on how the stripes are determined
and how often they change.

Thanks Andy - I have just played around with that, however
I need to do it with a Bubble Graph and whilest it will
work for a scatter graph, it doesn't seem to want to with
a Bubble graph...






to adapt it.

(http://www.geocities.com/jonpeltier/Excel/Charts/ColoredQu
adrantBackground.html)

--

Cheers
Andy

http://www.andypope.info

 

[Jon Peltier]

Microsoft has an article on their support site, explaining how to use a
macro to make a bubble chart. It doesn't make a real bubble chart (I
guess the support staff couldn't figure out that in VBA you need to put
the data into the chart before you set the chart type), but it simulates
it by using custom shapes for the markers, where the shapes are drawn
larger or smaller based on the 'bubble size' column. You could combine
this pseudo bubble chart with column or area chart series to get a
dynamically scaled background pattern.

XL: How to Use a Visual Basic Macro to Create a Bubble Chart
http://support.microsoft.com/support/kb/articles/q139/6/62.asp

- Jon

 

[Amanda]

Thank you, I am having a look at this now..

-----Original Message-----
Microsoft has an article on their support site, explaining how to use a
macro to make a bubble chart. It doesn't make a real bubble chart (I
guess the support staff couldn't figure out that in VBA you need to put
the data into the chart before you set the chart type), but it simulates
it by using custom shapes for the markers, where the shapes are drawn
larger or smaller based on the 'bubble size' column. You could combine
this pseudo bubble chart with column or area chart series to get a
dynamically scaled background pattern.

XL: How to Use a Visual Basic Macro to Create a Bubble Chart
..asp

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______



.