Charting

MattB · Apr 10th, 2002, 08:08 AM

My s/s consists of approx. 100 BOMs.
Each BOM returns 4 cells of interest: Material Cost, Material MHP, CEM cost & Build cost.
I need to graphically represent this data & would like to use pie charts, however this would be a v. laborious task for so many BOMs. Can anybody offer any advice?
Cheers
Matt

shades · Apr 10th, 2002, 09:43 AM

I had a similar situation. But I used groups of ten. For those ten I set up option buttons to correspond to each one in the ten. Then I linked the option button to the chart (through a reference cell), so that as I selected an option (in my case, qtrs and cumulative qtr summaries) the chart would reflect that specific qtr. There is probably a simpler way to do this, but it worked for me.

And this might be too cumbersome to do all 100, unless you set up navigation buttons to go to each set of ten.

Apr 10th, 2002, 09:43 AM	#2
shades Board Regular Join Date: Mar 2002 Location: Near the Land of Oz Posts: 1,550	I had a similar situation. But I used groups of ten. For those ten I set up option buttons to correspond to each one in the ten. Then I linked the option button to the chart (through a reference cell), so that as I selected an option (in my case, qtrs and cumulative qtr summaries) the chart would reflect that specific qtr. There is probably a simpler way to do this, but it worked for me. And this might be too cumbersome to do all 100, unless you set up navigation buttons to go to each set of ten. __________________ - old, slow, and confused ... but at least I'm inconsistent - (retired Excel 2003 user, 3.28.2008)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2002, 08:08 AM	#1
MattB Board Regular Join Date: Mar 2002 Posts: 62	My s/s consists of approx. 100 BOMs. Each BOM returns 4 cells of interest: Material Cost, Material MHP, CEM cost & Build cost. I need to graphically represent this data & would like to use pie charts, however this would be a v. laborious task for so many BOMs. Can anybody offer any advice? Cheers Matt