Auto Expanding Pie Chart
I am trying to create an auto expanding pie chart.
I have a list of data which is added to every day. It is used to log new suppliers. Each supplier is assigned a commodity. I have defined a wb range (CG) which looks at one column of the data (Commodity) There are 8 different commodity that the user can choose from. I would like the pie chart to show the percentage of new vendors by each commodity. At present I am doing this with a helper table which counts the number of occurances and then I base my chart on this. Does anyone know of a way I can do this without a helper table? TIA |
Edgar,
You can automate the pie chart via the use of defined range names. Jon Peltier's site has a list of resources that deal with this topic. Most of the examples deal with line and column charts but the concept can be easily applied to a pie chart. http://peltiertech.com/Excel/Charts/...hartLinks.html ---- Regards, John Mansfield http://www.pdbook.com "Edgar Thoemmes" wrote: I am trying to create an auto expanding pie chart. I have a list of data which is added to every day. It is used to log new suppliers. Each supplier is assigned a commodity. I have defined a wb range (CG) which looks at one column of the data (Commodity) There are 8 different commodity that the user can choose from. I would like the pie chart to show the percentage of new vendors by each commodity. At present I am doing this with a helper table which counts the number of occurances and then I base my chart on this. Does anyone know of a way I can do this without a helper table? TIA |
All times are GMT +1. The time now is 12:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com