Combine a Bubble chart with other chart type
I need to prepare a chart including below information:
Overdue size of 10 customers Overdue % of AR of 10 customers AR Outstanding days of 10 customers Target of Overdue % of AR Target of AR Outstanding days I am thinking of use a Bubble chart to demonstrate information of 10 customers and use a rectangle shadow to show the target. But I don't know how to add the rectangle shadow to a Bubble chart. Am I thinking in the right way and how to get that if yes? If I am not, is there any solution for the problem? Thanks. Christine |
Combine a Bubble chart with other chart type
On Tue, 17 Apr 2007, in microsoft.public.excel.charting,
Christine Ma said: I am thinking of use a Bubble chart to demonstrate information of 10 customers and use a rectangle shadow to show the target. But I don't know how to add the rectangle shadow to a Bubble chart. You can combine most chart types, but not a bubble chart. Would a rectangular Autoshape drawing be acceptable instead? If not, could you create a bubble or bubbles that fill the area, perhaps pasting a rectangle on to the bubble range to turn the circular bubbles into rectangular ones? -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Combine a Bubble chart with other chart type
Hi Christine,
One way to do this would be to chart two x-y series. Then paste circles and rectangles on to the series markers. Then use VBA to size the circles and rectangles to the proportions you want. Ed Ferrero www.edferrero.com I need to prepare a chart including below information: Overdue size of 10 customers Overdue % of AR of 10 customers AR Outstanding days of 10 customers Target of Overdue % of AR Target of AR Outstanding days I am thinking of use a Bubble chart to demonstrate information of 10 customers and use a rectangle shadow to show the target. But I don't know how to add the rectangle shadow to a Bubble chart. Am I thinking in the right way and how to get that if yes? If I am not, is there any solution for the problem? Thanks. Christine |
Combine a Bubble chart with other chart type
Thanks.
"Ed Ferrero" wrote: Hi Christine, One way to do this would be to chart two x-y series. Then paste circles and rectangles on to the series markers. Then use VBA to size the circles and rectangles to the proportions you want. Ed Ferrero www.edferrero.com I need to prepare a chart including below information: Overdue size of 10 customers Overdue % of AR of 10 customers AR Outstanding days of 10 customers Target of Overdue % of AR Target of AR Outstanding days I am thinking of use a Bubble chart to demonstrate information of 10 customers and use a rectangle shadow to show the target. But I don't know how to add the rectangle shadow to a Bubble chart. Am I thinking in the right way and how to get that if yes? If I am not, is there any solution for the problem? Thanks. Christine |
Combine a Bubble chart with other chart type
Thanks Del. Your advise does help.
"Del Cotter" wrote: On Tue, 17 Apr 2007, in microsoft.public.excel.charting, Christine Ma said: I am thinking of use a Bubble chart to demonstrate information of 10 customers and use a rectangle shadow to show the target. But I don't know how to add the rectangle shadow to a Bubble chart. You can combine most chart types, but not a bubble chart. Would a rectangular Autoshape drawing be acceptable instead? If not, could you create a bubble or bubbles that fill the area, perhaps pasting a rectangle on to the bubble range to turn the circular bubbles into rectangular ones? -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
All times are GMT +1. The time now is 02:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com