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

video lectures

,

Extra Questions

,

ppt

,

Free

,

shortcuts and tricks

,

Semester Notes

,

Previous Year Questions with Solutions

,

study material

,

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

,

Viva Questions

,

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

,

past year papers

,

practice quizzes

,

mock tests for examination

,

MCQs

,

pdf

,

Exam

,

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

,

Objective type Questions

,

Summary

,

Important questions

,

Sample Paper

;