Software

Ask something
Discussion Locked

Excel Pie chart

0 helpful
3 replies

by dcrish

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is is possible to create a pie chart that includes data points from different worksheets (in the same workbook)?

It's just a very simple spreadsheet where I'd like to choose a cell (data point) from 3 different worksheets and make a pie chart forcomparison.

Please help. I hope I've provided enuf ifno.

3 replies

by juliap

In the worksheet that you are creating the chart in, insert a blank sheet. In cell a1 thru a3 create links to your three worksheets. Formula should look something like =[book2.xls]!sheet1!A15. Then create the chart based on this data(which will be automatically update if there are changes in the original file).

by dcrish

Yeah, that works, but it's too convoluted for what I "really" want to do. I guess I oversimplified it when I said that it is a very simple spreadsheet. Actually, my customer who will be doing this has a longer list, and would like to just create pie charts from several worksheets--on the fly.

Thank you for the answer. I guess it just confirms that there is no easy way to do this in Excel for pie charts. I found that if it's another kind of chart, all I have to do is Add a Series.Thanks again.

This discussion is closed to new replies.