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

Up next

94 videos|62 docs|15 tests
Download as PDF

Up next

Explore Courses for Class 6 exam
Related Searches

Free

,

Sample Paper

,

past year papers

,

mock tests for examination

,

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

,

Extra Questions

,

Important questions

,

Summary

,

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

,

video lectures

,

pdf

,

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

,

Viva Questions

,

study material

,

MCQs

,

practice quizzes

,

Semester Notes

,

shortcuts and tricks

,

Objective type Questions

,

Previous Year Questions with Solutions

,

ppt

,

Exam

;