excel charts

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Charts

Excel Charts

resolvedResolved · Low Priority · Version 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:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips


Server loaded in 0.08 secs.