How to Draw Charts and Graphs in Excel Simply and Quickly

Learning how to draw charts and graphs in excel simply and quickly doesn't have to be complicated. This updated guide presents a clear workflow, practical checks, and troubleshooting advice you can use while completing the process.

How to Draw a Chart in Excel

Note: Instructions are performed on Excel 2010.

Suppose you have a data table as shown below and need to insert 2 charts on the same graph:

Step 1: Create a column chart

Select the data area, open Insert => select Column => select 2-D Column.

Step 2: Transfer data to secondary axis.

Select the Return Rows column.

Next, right click => select Format Data Series.

Step 3: Select Secondary Axis in Plot Series On.

The result after you select Secondary Axis will be as shown below:

Step 4: To draw a line chart for the Returned Rows column, do the following:

- Left-select Return row number (at this time a circle will appear on all yellow columns).

- Next, right-click -> select Change Series Chart Type.

Then select Line style -> click OK.

The result after you select is:

You can customize the chart to make it more beautiful. Open the Layout Tab to add titles on the right, left, data on the columns. To make it reasonable and to your liking.

Excel provides many different types of charts such as bar, line, and pie charts to help present data visually. Users can customize colors, titles, and coordinate axes to make the chart more clearly displayed.

Additionally, if you need to plot multiple charts on the same worksheet, you can use the automatic sorting and alignment feature in Excel, which makes data management easier, especially when working with reports or analyzing data.

Final Thoughts

The most reliable way to handle draw charts and graphs in excel simply and quickly is to follow the process in order, verify each important setting, and test the result before moving on. Use the guidance above as a practical reference, then adjust the details for your device, software version, or specific goal.