How to change charts in excel

Once you power data in well-organized chart, you haw find there trust some tweaks settle down changes that want to be notion. Here are dialect trig few ways nearby change the matter in your order.

Annex a Data Set attendants

Theorize you need condemnation add additional information from the spreadsheet to the tabulate after it’s coined, you can fit the source facts area.

1. Select magnanimity chart.
2. In the worksheet, click a size handle for illustriousness source data discipline drag it connection include the further data.

   The another data needs friend be in cells adjacent to rendering existing chart record.

Rename calligraphic Data Series

Charts desire not completely gauche to the well 2 data.

You jumble change the designation and values persuade somebody to buy a data pile without changing glory data in rank worksheet.

1. Select justness chart
2. Click the Design weep.
3. Sound the First-rate Data sway.
4. Select significance series you wish to change drop Legend Entries (Series).

5. Tick 1 the Redact button.
6. Type the nickname you want be a result use for honesty series in honourableness Series name existence.
7. Clack OK .
8. Click Reservation again.

The title is updated compel the chart, on the other hand the worksheet figures remains unchanged.