how to make a pie chart in excel without know percentage

How to make a pie chart in excel without know percentage how to#

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 make a pie chart in excel without know percentage how to#

How to build a chart off a table in Excel?