Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Editing Data in Charts | Visualizing Data with Charts and Graphs
Excel for Beginners
course content

Зміст курсу

Excel for Beginners

Excel for Beginners

1. Introduction to Excel
2. Entering and Formatting Data
3. Basic Formulas and Functions
4. Advanced Formulas and Functions
5. Data Management and Analysis
6. Visualizing Data with Charts and Graphs
7. Working with Worksheets and Workbooks

bookEditing Data in Charts

Alright, let's get busy with some real-time data editing right within our charts in Excel.

We'll dive into the practical aspects of changing the data that your charts are displaying. You'll learn how to edit, add and remove your series data.

Key Points

  • Use the Select Data button to change which data your chart is using;
  • Change the orientation of your chart data by using the Switch Row/Column button;
  • Use the Change Chart button to select a different chart;
  • Edit the range for your series data;
  • Add a new data series to your chart;
  • Remove irrelevant data series;
  • Change Horizontal Axis Labels;
  • Use the Switch Row/Column button to toggle data orientation;
  • Change the chart type.

Все було зрозуміло?

Як ми можемо покращити це?

Дякуємо за ваш відгук!

Секція 6. Розділ 6
some-alt