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