Class 6 Exam  >  Class 6 Notes  >  How to become an Expert of MS Excel  >  How to Make Charts Auto Update

How to Make Charts Auto Update | How to become an Expert of MS Excel - Class 6 PDF Download

  • When you create a chart in Excel, it's important to make sure it stays up to date, even if you add more data later on. Although you can manually adjust the chart's data range to include the new data, this can be tedious if you frequently update your spreadsheet.
  • Luckily, there is an easier way. Simply format your source data as a table, then create a chart based on that table. When you add more data below the table, it will automatically be included in both the table and the chart, keeping everything consistent and up to date.
The document How to Make Charts Auto Update | How to become an Expert of MS Excel - Class 6 is a part of the Class 6 Course How to become an Expert of MS Excel.
All you need of Class 6 at this link: Class 6
94 videos|62 docs|15 tests
Related Searches

pdf

,

video lectures

,

ppt

,

Extra Questions

,

Viva Questions

,

Semester Notes

,

mock tests for examination

,

Summary

,

Free

,

Objective type Questions

,

past year papers

,

study material

,

Previous Year Questions with Solutions

,

How to Make Charts Auto Update | How to become an Expert of MS Excel - Class 6

,

MCQs

,

Important questions

,

How to Make Charts Auto Update | How to become an Expert of MS Excel - Class 6

,

practice quizzes

,

How to Make Charts Auto Update | How to become an Expert of MS Excel - Class 6

,

shortcuts and tricks

,

Exam

,

Sample Paper

;