98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Graph
Graph
Resolved · 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...
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. |
Excel tip:Recovering Unsaved Work in Excel 2010Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back. |