Creating chart from a range of data

[enigme]

Hello All,

Apologies if this has already been solved, but I could not find it.
Below is a sample chart.
Left side is the data, and the right side is the chart I would like to create showing the totals.
Yellow is the range, the green and orange are the data that need to be added up.
Hope this makes sense.
I have been doing this manually and it gets tedious when the data range gets longer.
Is there a simple function to do this?

Thanks!!

 

[shamimarita]

Hello Enigme,

Yes, you can create the chart without manually entering the totals. A good approach is to calculate the totals for each region using a SUMIF formula and then create the chart from that summarized data.

Assuming:

• Column A contains the Region names
• Column F contains the Green values
• Column H contains the Orange values

Create a small summary table listing each region (NORTH, SOUTH, EAST, WEST, etc.). Then use formulas like these:

For the Green total:
=SUMIF($A$2:$A$100,B2,$F$2:$F$100)

For the Orange total:
=SUMIF($A$2:$A$100,B2,$H$2:$H$100)

Here, B2 contains the region name (e.g., NORTH). Copy the formulas down for the other regions.

Once the summary table is ready:

• Select the summary table.
• Go to Insert → Column Chart (or Bar Chart).

Excel will create the chart using the calculated totals, and it will update automatically if the source data changes.

Alternatively, you could also use a PivotTable with a PivotChart, which is often the quickest way to summarize and chart grouped data.

 

[enigme]

Thanks, Shamima!

 

[shamimarita]

You are most welcome. Keep exploring Excel with ExcelDemy. Help each other make the forum more useful.