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