Home / Computer / How to Make a Data Comparison Graph in Excel 2016 Spreadsheet – iSumsoft

How to Make a Data Comparison Graph in Excel 2016 Spreadsheet – iSumsoft

make a data comparison graph

Charts have always been popular as a powerful tool for excel. We often compare some data. In order to facilitate more intuitive browsing, I personally think it would be better to make a data comparison graph. So how to do it? Here’s how to do a data comparison diagram in an Excel spreadsheet.

Steps to make a data comparison graph in Excel 2016 spreadsheet:

Step 1: First, prepare the test data. We use the estimated amount and actual payment from January to December as the test data.

prepare the test data

Step 2: In the Excel table, select the Insert, and then select the histogram, which I think is a commonly used figure. The difference between the two sets of data can be seen at a glance.

select insert

Step 3: Right-click on the blank histogram and click Select Data.

click select data

Step 4: When the Select Data Source window appears, click the red arrow behind the Chart data range.

click red arrow

Step 5: Next, select our data table, then the data source ( Sheet1!$A$1:$C$13 )is displayed in the box.

select data table

Step 6: You’ll see this page.

appear this page

Step 7: This creates an initial histogram.

create an initial histogram

Step 8: We need to modify this histogram. First we select the estimated amount (in blue), then right click it and select Format Data Series.

right click estimated amount

Step 9: In the Series Options, select the Primary Axis and set the Gap Width to 100%. Then select the Format and set the shape fill into No Fill.

select primary axis

Step 10: Set the shape outline to 3 pounds and set the color.

set the shape outline

Step 11: Now the estimated amount is set up, andstart to design the actual payment. Select the actual payment, right – click it to select Format Data Series.

select format data series

Step 12: So here we’re going to set it to the Secondary Axis, and set the Gap Width to 350%. Then set the shape to fill with no padding.

choose secondary axis

Step 13: Set the shape outline to 3 pounds and set the color.

set the color

Step 14: Finally, let’s improve it. Select the actual payment, right click it to choose Add Data Labels to display the actual payment amount.

choose add data labels

Step 15: Now that we’re done, it’s clear that there’s a gap between the two sets of data.

make a data comparison graph

Loading...

>> Source Link

Check Also

2 Ways to Use SHAREit on Iphone Easily & Quickly

At a time when technology development was not as sophisticated as in the past if …

%d bloggers like this: