Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel charts

ResolvedVersion 2003

Nathalie has attended:
Excel Intermediate course

Excel Charts

How make a chart with few different columns not closed in the table ?

RE: Excel Charts

Hello Nathalie

Thank you for your question and welcome to the forum.

You can change the data reflected in a chart by:

1. Selecting the chart and going to Chart-Source Data, and selecting a different data range from the spreadsheet.

2. Select on one of the columns representing the series you'd like to remove from the chart, and press Delete. This will remove that particular series from the chart. To add alternative data, select the data from the spreadsheet, copy it, right-click on the chart and select Paste to add the data into the chart.

Kind regards
Amanda

Excel tip:

Using Excel's MODE function

Use Excel's MODE function to display the most common value present in a particular range of cells.

The Mode function looks like this:

=MODE(cell range)

As an example, if 35 is the most commonly recurring number in a particular cell range, then the function will display 35.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.