+ Reply to Thread
Results 1 to 10 of 10

Macro to adjust graphs based on input

  1. #1
    Registered User
    Join Date
    09-10-2010
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    6

    Macro to adjust graphs based on input

    Hi everyone,

    I'm having an issue with my macro. Here is my question.

    In excel say you want to make a graph and you have range say B9:B20 can you make that range variable on the values of another cell?

    So in Bx:By it would determing the range of the graph (x and y) based on cells H and I

    Something like this

    Range("B" & Range("H9") & ":B" & Range("I9") & ",D9" & Range("H9") & ":D" & Range("I9")), PlotBy:=xlColumns

    Thank you,

    George

    My code:

    Please Login or Register  to view this content.

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

    Re: Macro to adjust graphs based on input

    Something like this,

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-10-2010
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Macro to adjust graphs based on input

    Thank you for your help, the code works great but it doesn't select the whole range for graphing, it takes a range from say B9:B19 instead of B9:B20.

    Is there anything I can do to fix this?

    Also what if I want this repeated for different sets of data in the same worksheet (to make several graphs)? Can that be possible?

    Thank you greatly for your help.
    Last edited by geotr; 09-10-2010 at 11:15 AM.

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

    Re: Macro to adjust graphs based on input

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-10-2010
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Macro to adjust graphs based on input

    Here is what the part of the code looks like now...and it keeps going with more graphs: How do i make the code you gave me apply to this worksheet? Sorry for all the questions but I am fairly new at this.

    Thank you

    Please Login or Register  to view this content.

    What happens is that the user selects the months to graph and the formula (Cells H and I) figures out what cell number that would be. Then it graphs in row B reference cell H to row B reference cell I and the same for the other coordinates...D(H) to D(I)
    Last edited by geotr; 09-10-2010 at 12:45 PM.

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

    Re: Macro to adjust graphs based on input

    why not post the workbook with the code, it would make things a lot clearer

  7. #7
    Registered User
    Join Date
    09-10-2010
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Macro to adjust graphs based on input

    Hi Andy,

    Here it is. Thank you

    Quote Originally Posted by Andy Pope View Post
    why not post the workbook with the code, it would make things a lot clearer
    Last edited by geotr; 09-10-2010 at 03:27 PM.

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

    Re: Macro to adjust graphs based on input

    Yes. The first thing it wants to do is open a text file on YOUR pc.

    You need to include at least a couple of charts worth of test data.

  9. #9
    Registered User
    Join Date
    09-10-2010
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Macro to adjust graphs based on input

    Quote Originally Posted by Andy Pope View Post
    Yes. The first thing it wants to do is open a text file on YOUR pc.

    You need to include at least a couple of charts worth of test data.
    Here is some data.

    Thank you Andy
    Last edited by geotr; 09-10-2010 at 01:02 PM.

  10. #10
    Registered User
    Join Date
    09-10-2010
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Macro to adjust graphs based on input

    Got it!

    The second Graph:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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.06938 seconds
  • Memory Usage 9,097KB
  • Queries Executed 14 (?)
More Information
Template Usage (33):
  • (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
  • (5)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (10)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (10)postbit_legacy
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (4)showthread_bookmarksite
  • (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
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (46):
  • 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_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1