Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get address of last cell in range in Excel
  • Offset in Excel
  • Two-way lookup with VLOOKUP in Excel
  • How to create dynamic named range with OFFSET in Excel
  • How to use Excel COLUMN Function

Data Analysis Examples

  • How to Create One and Two Variable Data Tables in Excel
  • How to create running total in an Excel Table
  • Excel Pie Chart
  • How to calculate correlation coefficient Correlation in Excel
  • How to add Trendline to a chart in Excel

Data Validation Examples

  • Excel Data validation with conditional list
  • Excel Data validation must contain specific text
  • Excel Data validation must begin with
  • Excel Data validation exists in list
  • Excel Data validation require unique number

Data Series in Excel

by
  • Select Data Source
  • Switch Row/Column
  • Add, Edit, Remove and Move

A row or column of numbers that are plotted in a chart is called a data series. You can plot one or more data series in a chart.

To create a column chart, execute the following steps.

1. Select the range A1:D7.

2. On the Insert tab, in the Charts group, click the Column symbol.

3. Click Clustered Column.

Result:

Select Data Source

To launch the Select Data Source dialog box, execute the following steps.

1. Select the chart. Right click, and then click Select Data.

The Select Data Source dialog box appears.

2. You can find the three data series (Bears, Dolphins and Whales) on the left and the horizontal axis labels (Jan, Feb, Mar, Apr, May and Jun) on the right.

Switch Row/Column

If you click Switch Row/Column, you’ll have 6 data series (Jan, Feb, Mar, Apr, May and Jun) and three horizontal axis labels (Bears, Dolphins and Whales).

Result:

Add, Edit, Remove and Move

You can use the Select Data Source dialog box to add, edit, remove and move data series, but there’s a quicker way.

1. Select the chart.

2. Simply change the range on the sheet.

Result:

Post navigation

Previous Post:

Chart Axes in Excel

Next Post:

Error Bars in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Join Text Strings Using Concatenate or ‘& Operator’ in Excel
  • SUBSTITUTE function: Description, Usage, Syntax, Examples and Explanation
  • How to count specific words in a cell in Excel
  • SEARCH, SEARCHB functions: Description, Usage, Syntax, Examples and Explanation
  • How to extract multiple lines from a cell in Excel
  • DAY function: Description, Usage, Syntax, Examples and Explanation
  • Convert date string to date time in Excel
  • How to enter Today’s Date or Static Date and Time in Excel
  • Calculate days remaining in Excel
  • YEAR function: Description, Usage, Syntax, Examples and Explanation
  • DURATION function: Description, Usage, Syntax, Examples and Explanation
  • How to Calculate Tax Rates in Excel
  • How to calculate principal for given period in Excel
  • How to calculate annuity for interest rate in excel
  • CUMPRINC function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles