+ Reply to Thread
Results 1 to 8 of 8

Change chart values based on cell drop down

  1. #1
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Change chart values based on cell drop down

    Hello all

    I'm relatively ok with VBA but 100% useless at charts so this may seem obvious to others.

    I want my column chart data to change with the value of a drop down.

    I've attached a workbook so you can see the data etc.

    Also, because some data is formatted as percentages and some as numbers and some as ratios; would it be better to group these into different charts?

    Many thanks in advance

    Graphs.xlsx

  2. #2
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Change chart values based on cell drop down

    Hi,

    Check this

    Punnam
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Re: Change chart values based on cell drop down

    This is brilliant!

    So simple yet so effective - thank you Punnam

  4. #4
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Re: Change chart values based on cell drop down

    Also, I guess I'll have to find another way to show the ratios

  5. #5
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Change chart values based on cell drop down

    PDBartlett ,

    I tried but no luck , let see some other can help you in this regard

    Punnam

  6. #6
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Re: Change chart values based on cell drop down

    Punnam, how would I change the colours of the min and max values for each KPI on the chart?

  7. #7
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Change chart values based on cell drop down

    HI PDBartlett ,

    I think that can be done only with the help of macros , ( i am not having knowledge in macros) post a new thread in the following link
    http://www.excelforum.com/excel-programming-vba-macros

    Punnam

  8. #8
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Change chart values based on cell drop down

    Are all your ratios x:1? If so, just remove the :1 part (you can put it back with a custom format if necessary).
    Remember what the dormouse said
    Feed your head

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Locking a formula in a column where the values change based on drop down menu
    By uhm_81 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2014, 09:57 PM
  2. [SOLVED] Change a cell based on a drop down list
    By nickmax1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-24-2012, 06:25 AM
  3. Replies: 1
    Last Post: 03-26-2012, 02:52 PM
  4. change cell values based on drop down box selection
    By Aniruddha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2006, 05:30 PM
  5. How to change drop down values based on another cell value?
    By puneetarora_12 in forum Excel General
    Replies: 3
    Last Post: 10-05-2005, 07:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1