The optimal variant is to create a dynamic chart that will update automatically.
If you need to add new data in the bar chart very often, it's not convenient to change the range every time. The values for rows and categories will swap around automatically. In the menu you've opened, click the «DESIGN»-«Switch/Column» button. There is a more complicated way of adding new data into the existing graph through the «DESIGN» «Select Data» menu (open it by right-clicking and selecting «Select Data»).Īfter you click «Add» (legend elements), there will open the row for selecting the range of values. As it's not entirely clear where the figures in our bar chart come from, let's create the legend.Select the existing chart and paste the fragment (by pressing Ctrl+V). Copy it to the clipboard (by pressing Ctrl+C). Select the new range of values, including the heading.Add new values to the table – the «Plan» column.Go to the «DESIGN» tab, select «Data Labels» and the desired position.Īs a result, we have a stylish presentation of the data in Excel. Specify the sums by giving titles to the bars.Select the vertical axis and its title type. Go to «CHART TOOLS» - «DESIGN» - «Add Element» - «Axis Titles» - «Primary Vertical». Double-click on the bar chart's title and enter «Total Amounts». Such a variant isn't exactly what we need, so let's modify it.After you choose your bar chart type, it will be generated automatically.Click «Insert Column Chart» (as an example you may choose a different type).Go to the «INSERT» tab and choose the type. Select the range of values A1:B5 that need to be presented as a chart.
How to build a chart off a table in Excel? The link at the end of the article will allow you to download a sample template. Moreover, we will learn to create dynamic charts and graphs, which are updated automatically when you change the data. In this case, charts are the optimal variant of representation. It's particularly relevant for numeric data that needs to be compared. How to build a chart on a table in Excel: step by step instructionĪny information is easier to perceive when it's represented in a visual form.
0 kommentar(er)
