Colouring Chart backgrounds

  • Thread starter Thread starter Amanda
  • Start date Start date
A

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
 
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...
 
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)
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
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
 
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
_______



.
Click to expand...
 
Back
Top