| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
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=e...%40tkmsftngp09) The choice of approach really depends on how the stripes are determined and how often they change. Amanda wrote: > 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... > > > > > >>-----Original Message----- >>Hi Amanda, >> >>Take a look at Jon Peltier's example, you should be able > > to adapt it. > > (http://www.geocities.com/jonpeltier/...arts/ColoredQu > adrantBackground.html) > >>Amanda wrote: >> >>>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 >> >>. >> -- Cheers Andy http://www.andypope.info |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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.../q139/6/62.asp - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Andy Pope wrote: > 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=e...%40tkmsftngp09) > > > The choice of approach really depends on how the stripes are determined > and how often they change. > > Amanda wrote: > >> 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... >> >> >> >> >> >>> -----Original Message----- >>> Hi Amanda, >>> >>> Take a look at Jon Peltier's example, you should be able >> >> >> to adapt it. >> >> (http://www.geocities.com/jonpeltier/...arts/ColoredQu >> adrantBackground.html) >> >>> Amanda wrote: >>> >>>> 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 >>> >>> . >>> > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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 >http://support.microsoft.com/support...cles/q139/6/62 ..asp > >- Jon >------- >Jon Peltier, Microsoft Excel MVP >http://www.geocities.com/jonpeltier/Excel/index.html >_______ > >Andy Pope wrote: >> 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%40tkmsftngp09) >> >> >> The choice of approach really depends on how the stripes are determined >> and how often they change. >> >> Amanda wrote: >> >>> 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... >>> >>> >>> >>> >>> >>>> -----Original Message----- >>>> Hi Amanda, >>>> >>>> Take a look at Jon Peltier's example, you should be able >>> >>> >>> to adapt it. >>> >>> (http://www.geocities.com/jonpeltier/...arts/ColoredQu >>> adrantBackground.html) >>> >>>> Amanda wrote: >>>> >>>>> 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 >>>> >>>> . >>>> >> > >. > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Colouring area under curve in a scatter chart? | Ed Ferrero | Microsoft Excel Discussion | 1 | 16th Nov 2007 01:52 PM |
| Tool for colouring backgrounds of cells in tables | =?Utf-8?B?UGV0ZSBSb29uZXk=?= | Microsoft Word Document Management | 3 | 6th Nov 2007 03:29 PM |
| Colouring error bars in a chart | Graham Whitehead | Microsoft Excel Programming | 1 | 4th Aug 2006 02:59 PM |
| determine colouring of variables of a pie chart | =?Utf-8?B?TWVuam8=?= | Microsoft Excel Charting | 1 | 8th Aug 2005 11:28 PM |
| Pie Chart Colouring - for top surface of slices only | =?Utf-8?B?U3V6IENhbXBiZWxs?= | Microsoft Excel Charting | 1 | 19th Jul 2005 03:08 AM |
