How To Create A Comparison Graph In Excel

How to Create a Comparison Chart in Excel

Step 1 – Launch Excel

To create a comparison chart in Excel, launch the MS Excel desktop app, and select a blank workbook.

Step 2 – Enter Data

Now enter your data in the workbook. There are many ways of doing that: either copy & paste from another file or you can manually type everything. For this how-to tutorial, we will insert sample data manually. Once you have entered the data, select it.

excel enter data

Step 3 – Inset Comparison Chart

Excel does not have a built-in comparison chart or any comparison chart template Excel. So to create a comparison chart in Excel, we will click on theBorder icon inHome Tab. Click on the drop-down arrow and select All Borders. Once you click onAll Borders, borders will highlight each cell. Another way of doing this is by clicking onTable in theInsert Tab.

Step 4 – Customize

Now a basic comparison chart in Excel is ready. You can edit and customize it to your liking. Excel has many formatting tools to use. You can change the font, add images, add watermark, change colors, and a lot more. Use theInsert Tab andHome Tab to explore all the different options. To add more detail and definition to your comparison chart, edit the border by clicking onMore Borders underBorders in theHome Tab.

excel customize chart

Step 5 – Save

When your comparison chart in Excel is complete, you can save your final document. Go toFile and click onSave. A popup window will appear on your screen. Name your file, browse file location, and click onSave to save your file.

How to Create A Comparison Chart in EdrawMax

Being a multi-purpose graphics tool for visual content, EdrawMax Online has a wide range of templates for you. As stated earlier, there is no comparison chart template Excel, but Edraw can be used to create more than 20 types of diagrammatic content. To create a comparison chart in Edraw, follow our tutorial on how to create a comparison chart using Edraw.

Step 1 – Go to Edraw

Open EdrawMax Online using this link https://www.edrawmax.com/online/.

open edrawmax

Step 2 – Search Template

Now scroll down toGraphs and Charts in the navigation pane given on the left side of the screen. Once you click onGraphs and Charts, different types of charts option will be given along with various templates. Now selectComparison Chart and search through the templates. You can use a free Edraw Comparison Chart template or create a blank page to make one from scratch. We will use a free template for this tutorial. Once you click on a template, a new Edraw Tab will open.

edrawmax open template

Step 3 – Add Data and Customize

Now you can edit and customize your comparison chart using different formatting tools on the right side of the screen. Adjust the size, shape, color, alignment, and other details according to your liking. You can enter all the relevant data in your comparison chart by simply typing it.

edrawmax customize chart

Step 4 – Save

Once you have completed the comparison, you can save the file for later use or edits.

EdrawMax Online

Create 280+ types of diagrams online

Access diagrams anywhere, anytime

Everything in desktop + Templates Community

Team management and collaboration

Personal Cloud and Dropbox Integration

EdrawMax Desktop

Create 280+ types of diagrams

Support Windows, Mac, Linux

Full access to resources and templates

On-premises software for business

Enterprise-level data security

How to Save an Edraw Chart as an Excel File

EdrawMax Online enables you to export and share Edraw documents in the file format of MS Excel and other software. To save an Edraw file as MS Excel document, click onFile > Export and click onExport to Excel (.xlsx). In this way, you can view and edit your Comparison Chart in Excel and share it with those who use the corresponding software.

edrawmax save export

You can also save Edraw documents in Google Drive and Dropbox for online sharing and cloud protection. Click onFile, and thenSave as. Select the desired cloud location and click onOK.

Our essential tutorial on how to make a comparison chart in Excel and EdrawMax Online ends here.