excel vba automatic graph

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA Automatic Graph Range Assignment | Excel forum

Excel VBA Automatic Graph Range Assignment | Excel forum

resolvedResolved · High Priority · Version 2007

Francis has attended:
Excel VBA Intro Intermediate course

Excel VBA Automatic Graph Range Assignment

Hello,

I am using Microsoft Excel VBA 2007 for annual energy use simulation over a year, on an hour by hour basis.

This generates arrays of 8760 numbers (no. of hours in a 365 day year) which I store in named ranges on various worksheets.

I am interested in writing a sub-procedure that would identify from the 8760 number range where the peak energy consumption is and plot a graph showing the 24 hour range that this peak value falls within.

I can use a worksheet function to quickly locate the element in the array that holds the max value for the whole named range, but how do I then write something that shifts the min/max value of the x-axis on the graph to the day (i.e. 24hour range) which this max-value falls under?

I am sure this must be possible but am struggling with chart objects at the moment so any help would be much appreciated!

Best Regards,

Francis

RE: Excel VBA Automatic Graph Range Assignment

Hi Francis

Thank you for your post and detail of what you are trying to do, I have shared this with a colleague and we are reasonably sure that a solution can be reached, just beyond the scope of this forum.

What we would ask is for you to email your working files to us so we can review and identify a solution. Once we have done this we will inform you of the scope of work (durations, costs) to achieve this for you to decide if you wish to engage or not.

Please email me if you wish to discuss further:

Kind regards

Jacob@stl-training.co.uk

Tue 9 Nov 2010: Automatically marked as resolved.

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Navigate with keyboard without losing your active cell

If you like using your keyboard to scroll through your excel document, but want to keep your active cell the same, use the scroll lock, and then use your arrow keys to navigate around the document.

View all Excel hints and tips


Server loaded in 0.07 secs.