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
92 videos|62 docs|15 tests
Related Searches

Extra Questions

,

past year papers

,

Sample Paper

,

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

,

Summary

,

shortcuts and tricks

,

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

,

study material

,

Important questions

,

ppt

,

Objective type Questions

,

video lectures

,

pdf

,

practice quizzes

,

Semester Notes

,

Previous Year Questions with Solutions

,

Exam

,

Viva Questions

,

mock tests for examination

,

Free

,

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

,

MCQs

;