+ Reply to Thread
Results 1 to 3 of 3

Dynamic Chart w/ ComboBox Issue

  1. #1
    Registered User
    Join Date
    05-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    21

    Dynamic Chart w/ ComboBox Issue

    In my attached sample file I have a set of data that I am charting dynamically using a form comboBox. Problem is that there is no way to change the font size unless I use an active x comboBox. Problem is it is not liking my offset formulas when I switch to the active x ComboBox. I've tried numerous workaround and no luck. Any help would be greatlly appreciated as I need to change the font size in the combo box for a project at work I am working on.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,115

    Re: Dynamic Chart w/ ComboBox Issue

    As the activex combo returns the item rather than its index position you need to use an additional formula to do that.

    =OFFSET(A6,0,MATCH($K$1,$I$2:$I$4,0))

    where the MATCH formula replaces the $K$1 reference.

    Or you could do the match in L1 and then reference that cells value.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Dynamic Chart w/ ComboBox Issue

    Quote Originally Posted by Andy Pope View Post
    As the activex combo returns the item rather than its index position you need to use an additional formula to do that.

    =OFFSET(A6,0,MATCH($K$1,$I$2:$I$4,0))

    where the MATCH formula replaces the $K$1 reference.

    Or you could do the match in L1 and then reference that cells value.
    Worked like a charm! I was missing the match formula it seems. Never used that before.. Will have to keep this in mind for future reporting =D.

+ 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. ComboBox Issue
    By Guido Meng in forum Excel General
    Replies: 0
    Last Post: 03-27-2013, 12:17 PM
  2. Combobox source , linked to other combobox value ??(DYNAMIC)
    By stevnb in forum Excel Programming / VBA / Macros
    Replies: 40
    Last Post: 01-25-2013, 05:28 AM
  3. Dynamic chart with combobox and scrollbar
    By najort in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-30-2012, 11:06 PM
  4. Chart Title from Dynamic Range Issue
    By a2excel in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-10-2012, 03:41 AM
  5. Dynamic chart and blank entries....wierd issue....anyone know whats going on
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-29-2011, 11:44 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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06621 seconds
  • Memory Usage 8,929KB
  • Queries Executed 16 (?)
More Information
Template Usage (35):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)bbcode_quote
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (3)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (1)postbit_attachment
  • (3)postbit_legacy
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (4)showthread_bookmarksite
  • (5)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (49):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1