graph

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Graph

Graph

resolvedResolved · Low Priority · Version Standard

Nick has attended:
Access Introduction course

Graph

Hi

I have a series of graphs for which the underlying data is updated each month. I do not want the graphs to pick up "empty" months so am currently manually changing the 'source data' each month to add the new months data - is there a way that the graph can automatically identify that there is a new months data and automatially update the source data in the chart or does this task have to be performed manually each month?

Cheers
NICK

RE: Graph

Dear Nick

Thank you for attending Access Introduction!! I hope you enjoyed the course.

Please find uploaded file for your reference.

It is important to note that the chart and the source data are linked to each other. This means that the chart gets automatically updated if you add or amend the data in the spreadsheet.

On the uploaded file you

Attached files...

Monthly sales Chart.xls

 

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:

Recovering Unsaved Work in Excel 2010

Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back.

Choose File then Info, click Manage Versions and then Recover Unsaved Workbooks which will automatically find the spreadsheets that haven't been saved.

View all Excel hints and tips


Server loaded in 0.08 secs.