Create pie and column charts on new worksheets in personal budget workbook

**EJensen** · 10-17-2009, 05:31 PM

I attached two workbooks named Event Budget2 and Personal Budget Workbook. I want to create new worksheets with charts in the Personal Budget Workbook that are linked to the Personal Budget Workbook but look like the charts in Event Budget2 workbook. However, I am not doing well with it on my own. Can you help me do that and/or tell me how to do that?

**Andy Pope** · 10-18-2009, 05:45 AM

You need to select non contiguous ranges to get labels and values.
Start by inserting a chart. The use the Source Data dialog to amend the series references.
In the values area you need to select the first cell and then using the CTRL key select each other cell.
Repeat for labels.

And it would really help if the cells had non zero values as the pie will appear as a vertical line otherwise.

Alternatively you could produce a small contiguous table for the chart that linked to the subtotal names and values. The the chart would be easy to create.

As far as the charts go consider losing the fake 3d views. They will disort your charts and make them hard to read.

**EJensen** · 10-18-2009, 12:38 PM

Hi Andy, thank you for your instructions. I appreciate it very much. However I need a lot of help and a little bit more detailed instruction specific to the attached documents. I am having a hard time figuring this out on my own. Thank you for being so generous and helpful.

**Andy Pope** · 10-19-2009, 04:41 AM

Make a table of chart data by simply linking to the appropriate cells.

As I say in order for the pie to have any slices you need values.

**EJensen** · 10-20-2009, 07:33 AM

Wowzers! This is exactly what I was striving for. Thanks man!

**Sideshow Hob** · 11-20-2009, 07:33 PM

I like the look of this worksheet. You have one monthly tab?? Is it just a case of copy and paste values each month and copy the forumulas into the next month in the yearly tab??