How to Do a Two-Sided Graph in Excel. Microsoft Excel can present two series of data points together on the horizontal axis, but if the number scale for each series dramatically differs, the data ...

Choose between chart-only and chart-and-analysis versions for either Excel 2003 or Excel 2007. Note that the Excel 2007 templates are compatible with Excel 2010.

Let’s delve into these steps in detail. First, you need to insert a chart into your spreadsheet. You can enter any kind of chart – no matter whether it is a simple 2D, 3D, or anything else.

Step 2: Make an Excel Bar Chart To start to visualize your data, you’ll first create an Excel stacked bar chart from the spreadsheet. Select the “Start date” column, so it’s highlighted.