charts

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 » Charts

Charts

resolvedResolved · Medium Priority · Version 2003

Edited on Wed 30 Mar 2011, 14:46

Lyndon has attended:
Excel VBA Advanced course

Charts

I want to get the maximum axis value from a chart (in Excel 2003), so I can use VBA to set appropriate axis number formats. Using the macro recorder does not help with 2003.

RE: Charts

Hi Lyndn, thanks for your query. I think you and I covered this on Day 2 with the help of the 2007 macro recorder which drills into charts in more depth. Let me know if I can be of further assistance.

Hope this helps,

Anthony

Wed 6 Apr 2011: 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:

Random Numbers

Type =RAND()*200 to generate a number between 1 and 200.
Use the fill handle to drag down and populate as many cells as you'd like with random numbers.

View all Excel hints and tips


Server loaded in 0.08 secs.