workbook charting

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Workbook Charting

Workbook Charting

resolvedResolved · High Priority · Version 2003

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

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):
https://www.stl-training.co.uk/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:
https://www.stl-training.co.uk/excel-course-in-london-2003-vba.php

Kind regards
Amanda

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.

 

Training courses

 

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
What does 'Resolved' mean?

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


 

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips


Server loaded in 0.11 secs.