Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / May 2008

Tip: Looking for answers? Try searching our database.

Bubble Chart - Edit Color in plot area

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Scent - 08 May 2008 08:25 GMT
Hi,
I wish to edit the color within the plot area from point A but they only
allow me to select the whole area and change.
Below is an example. I wish to color the area R in red. How to do about it?
I do have bubbles around the plot area but don't need to make any change to
them. I just want some good advice on the plot area. Will appreciate some
help here.

Y axis

    5           Red (Area R)
    4 ____________________
    3           Yellow (Area Y)
    2 ____________________
    1 _______Green (Area G)_      
            A        B      C      D      
             
                  X axis

Thanks!
Andy Pope - 08 May 2008 10:10 GMT
Hi,

You would normally create the banding effect using a combination chart.
Unfortunately you can not create combinations including a bubble chart.
You could create the bands using autoshapes and the using MS Paint create a
image that is used as the fill pattern for the plot area. You would need to
make the shapes the same size as the plotarea they will cover. Of course the
image will be static.

You could also try using 2 charts. The top bubble chart would have no chart
area fill making it transparent. Underneath that chart would be another
containing a column chart to provide the banding. Aligning the 2 charts
might be tricky though.

Here is Jon's page on creating banding effects using combination charts
http://peltiertech.com/Excel/ChartsHowTo/HorizBands.html

Cheers
Andy

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

> Hi,
> I wish to edit the color within the plot area from point A but they only
[quoted text clipped - 18 lines]
>
> Thanks!
Andy Pope - 10 May 2008 18:29 GMT
I have posted some code and explanation on how to get the appearance of
banding on a bubble chart
http://www.andypope.info/charts/Bubblechart_banding.htm

Cheers
Andy

> Hi,
>
[quoted text clipped - 15 lines]
> Cheers
> Andy

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.