Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Charting

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    Board Regular shades's Avatar
    Join Date
    Mar 2002
    Location
    Near the Land of Oz
    Posts
    1,550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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)

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •