Bubble Chart - Edit Color in plot area
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! |
Bubble Chart - Edit Color in plot area
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/ChartsH...orizBands.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Scent" wrote in message ... 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! |
Bubble Chart - Edit Color in plot area
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 Andy Pope wrote: 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/ChartsH...orizBands.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 10:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com