Charting

[MattB]

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]

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.