Growing circles

[Sal1283]

Hi,

How can I create a growing proportional circles in excel? For eg.: If my departments sales were $100 5 years ago and they are $1,000 now and I want to show the growth via two circles that are proportionate to the growth?

Thank you for your help.

 

[Smitty]

Welcome to the Board!

Check out Bubble Charts:

http://office.microsoft.com/en-us/excel-help/creating-a-bubble-chart-HA001117076.aspx

http://peltiertech.com/Excel/Charts/ControlBubbleSizes.html

HTH,

 

[JoeMo]

I'm not clear on how you want these circles to appear, but you might consider using a Bubble Chart. Maybe something like this:

Excel Workbook
	A	B	C	D
1	Index	1	2	3
2	Year	1999	2005	2011
3	Sales	$100	$1,000	$5,000
4	*	*	*	*
Sheet2

Each column (B:D) contains a data series for one bubble. The index determines the horizontal position of each bubble, the year determines the vertical position, the bubble size scales with the sales volume. You can format the chart so each bubble has a year and sales$ value beneath it.

 

[Sal1283]

Thank you Smitty and JoeMo. Your suggestions were very helpful and does help in terms of showing the growth. But I was trying to figure out more on how to do this without using bubble charts so I can only have two circles on a page with an arrow in between to show the growth (no horizontal and vertical axis).

Furthermore, the department also has some subdivisions so the circles will look more like pie charts, thats why I am trying to do this without the bubbles.

If you guys know of a way to do this without bubble charts - please let me know. I'd really appreciate your help.

Thank you for your time.

 

[Smitty]

You might want to take a look at Visio then. It can link data from an Excel worbook, as well as joining shapes (provided you give it a linkable reference between them). If you don't have Visio, then I think that Bubble charts in Excel are about the only option (unless you want to do it manually).

 

[Sal1283]

Thank you Smitty! I appreciate your help.