Forum home » Delegate support and help forum » Microsoft Excel Training and help » Graphs
|
|
|
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. |
Graphs
Resolved · Low Priority · Version 2007
Reply Mon 15 Aug 2011, 15:53Delegate Chris said...
Chris has attended:
Excel Intermediate course
Graphs
If I add data to the range in a table, can excell automatically update the graph without me having to drag the data souce box over the new data?
For upcoming training course dates see: Pricing & availability
RE: Graphs
Hi Chris
Thank you for your question.
I have had a look at the Microsoft website and the following link takes you to a page that describes ways of updating a chart - all but one require the source values to be edited however.
http://office.microsoft.com/en-us/excel-help/add-data-to-a-chart-HP005198472.aspx#BMdifferentdata
The exception is in the section called:
COPY WORKSHEET DATA INTO A CHART
It will only work with embedded charts but may be worth testing on a back up copy of your report. It still requires user input but uses copy and paste rather than having to drag or edit data ranges. Although it's listed as relating to Excel 2003 the copy and paste approach works in 2010.
A different approach would be to convert your source data to a table (Home ribbon > Style group > Format as Table.
If you base your chart on data in the table and add a new record to the table the chart will automatically update to include the data.
I hope these two approaches help. Let me know if you have any further questions.
Kind regards,
Andrew
Mon 22 Aug 2011: Automatically marked as resolved.
|