Forum home » Delegate support and help forum » Microsoft Excel Training and help » Workbook Charting
|
|
|
The UK's most regular Training information: See also: |
|
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Workbook Charting
Resolved · High Priority · Version 2003
Reply Tue 11 Nov 2008, 17:13Delegate Deorne said...
Deorne has attended:
Excel Intermediate course
Excel Advanced course
Workbook Charting
Hello,
I have a report with two tabs in the same workbook. The first tab contains the raw data and the second tab contains 11 charts pertaining to that data.
the data in tab1 is updated each month showing the current months results and the previous 5 months, 6 months in total. The charts on the 2nd tab also include 6 months data.
I currently manually update the data in tab1 and the manually update the 'Series' in each of the charts in tab2.
Q1. Can I set this up so that the charts auto update each month when I update the raw data?
Q2. If so, can you tell me how this can be done?
Many thanks
Regards,
Deorne Richardson
07711 967603
For upcoming training course dates see: Pricing & availability
RE: Workbook Charting
Hello Deorne
Thank you for your question and welcome to the forum.
I presume that the data on tab 1 is not always in exactly the same cells each time, as you are adding a new month's data in, hence the reason why you need to manually update the Series tab for each chart.
I would think that it would be possible to automate this process, but it would requiring writing VBA code in Excel to accomplish this.
This is something we could assist with, but on a consulting basis therefore it would be billable time. If you would be interested in exploring this option further, please contact our enquiries team (see following link for ways to contact):
http://www.microsofttraining.net/contact/index.php
If you are doing a lot of work in Excel that you feel could be automated, it might be worth considering taking our 2 day Excel VBA course:
http://www.microsofttraining.net/excel-course-in-london-2003-vba.php
Kind regards
Amanda
Reply Tue 9 Dec 2008, 10:56Delegate Deorne said...
RE: Workbook Charting
Hi Amanda,
Thanks you for the response to my question.
I will consider the VBA couse as a lot of the work I'll need to do going forward will require automation.
Kind regards,
Deorne
Thu 27 Nov 2008: Automatically marked as resolved.
|