#CHANGE DATA IN EXCEL CHART HOW TO#

Here is how the Select Data Source window looks before: This only works with 1 data series so I have removed Costs for this example: Basically what this feature does is swap your Legend Entries (Series) round with your Horizontal Axis Labels (Category). It can also give you an alternative layout for your chart, which may be better depending on how you plan on using your chart. Switching the Row/Column of your data can come in handy if data in a worksheet has a poor layout. Switching Rows/Columns in Charts in Excel So for example I am going to move the Costs data series up: To move a series up and down, select it then click the up/down arrows to rearrange. The following window will open allowing you to change the series name and referenced data: To edit a data series, select it then click the Edit button under the Legend Entries section. Note: I have added the Costs data series back in for the rest of the tutorial. For example I am going to remove the data series I just added: To remove a data series, select it then click the Remove button. This allows you to select a new series name and a reference to the cells which contain the new series data. To add another data series to your chart, simply click the Add button. I will now expand this with a new selection:

In the previous tutorial I only had 10 items for my chart.

To change the data used in a chart, clear the current data reference in the Chart data range box at the top of the window (click the button to the right of the box to minimize the window if required) then select your new data. To edit the data selection of a chart, right click the chart and select the Select Data option - or select the chart, go to the Design tab, and click the Select Data button from the left side of the ribbon menu.ДЇrom now on the tutorial will discuss features from this pop-up window: This tutorial is split up in order to breakdown the Select Data Source window into small and easy to understand parts.

#CHANGE DATA IN EXCEL CHART HOW TO#

In this tutorial I am going to show you how to update, change and manage the data used by charts in Excel.

Change data in excel chart