# Macro to adjust graphs based on input

1. ## 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. ## Re: Macro to adjust graphs based on input

Something like this,

``Please Login or Register  to view this content.``

3. ## 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.

4. ## Re: Macro to adjust graphs based on input

``Please Login or Register  to view this content.``

5. ## 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)

6. ## Re: Macro to adjust graphs based on input

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

7. ## Re: Macro to adjust graphs based on input

Hi Andy,

Here it is. Thank you

Originally Posted by Andy Pope
why not post the workbook with the code, it would make things a lot clearer

8. ## 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. ## Re: Macro to adjust graphs based on input

Originally Posted by Andy Pope
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

10. ## Re: Macro to adjust graphs based on input

Got it!

The second Graph:

``Please Login or Register  to view this content.``

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

#### 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 (?)
Template Usage (33):
• (5)bbcode_code
• (2)bbcode_quote
• (1)footer
• (1)forumrules
• (1)gobutton
• (10)memberaction_dropdown
• (1)navbar
• (4)navbar_noticebit
• (6)option
• (10)postbit_legacy
• (10)postbit_onlinestatus
• (10)postbit_wrapper
• (1)spacer_close
• (1)spacer_open
• (1)tagbit_wrapper

Phrase Groups Available (6):
• global
• inlinemod
• postbit
• posting
• reputationlevel
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
• ./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_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_foruminfo
• global_state_check
• global_bootstrap_complete
• global_start
• style_fetch
• global_setup_complete
• friendlyurl_redirect_canonical
• bbcode_fetch_tags
• bbcode_create
• postbit_factory
• postbit_display_start
• 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