Create a chart with pictures to show percentages

[bgriffith005]

I would like to make an illustration to show what percentage of income is being spent in several categories: Taxes, debt, lifestyle, giving, saving. I would like to illustrate this on a picture like a $100 bill or the like (something similar to what I have attached). Any tips or suggestions on how to do this? Any help is appreciated!

Thanks,
Brad

[Andy Pope]

http://www.andypope.info/charts/dollarsplit.htm

[bgriffith005]

Andy,

Thanks! That is exactly what I was looking for. Is there a way to change the pictures easily? I figured out how to change some, but not the ones on the MoneyShare tab. Also, if I am changing the categories and/or the amounts, where should I make those changes so it would reflect in the MoneyShare image displays?

Thanks!!!

[Andy Pope]

Here is a version saved in the new file format.

You can change the values/descriptions in columns A:B of first sheet.

To change the image you need to format either the plot area or series Fill picture property.

[bgriffith005]

Thanks. On what tab/chart am I changing the image? I changed the images on several of the other tabs but it does not reflect on the first tab. Sorry, I do not use charts/graphs too often in excel.

[Andy Pope]

The workbook has 3 sheets. 1 showing the result of both approaches. The other 2 sheets detailing how to construct the chart, albeit in xl2003.

just select the chart you want to change and format either the plotarea or each series, depending on which approach you want to use.

[bgriffith005]

Awesome! I got it figured out, thanks so much!!!!