Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: I cant remember how to do this??? Chart that allows you to c

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I saw this on the back of an excel book....and of course I cannot find the book right now

    Lets say I have three columns of data, 1) Products, 2) L52 Wk Sales, 3) L12 Wk Sales

    I would like to build a chart that is based off of the products column and one of the time period columns. But this is the kicker, I want to be able to choose which time period is displayed in the chart. And I want to format the spreadsheet so that a non-excel techie can easily do this.

    For example, I create a sales report and send it to my boss. He should be able to chose his own time period without having to call and ask how.

    I think I remember seeing somthing like a dropdown box and you choose from the box. But I cant remember the key words to look up in the excel books that I have.

    Any help you can give me would be greatly appreciated!

    Kulata

    [ This Message was edited by: kulata on 2002-05-01 20:41 ]

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default



  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Adelaide, Australia
    Posts
    182
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What you are thinking of is a pivot chart.

    Refer to the excel help files on this topic, they are quite helpful.

    Good luck
    Stuart

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
  •