How To Create Graph In Excel 2016

Instics vs. Excel

How to Make a Bar Graph in Excel 2016 for Windows - Instics vs. Excel

February 24, 2017· excel

In this edition of Instics vs. Excel, we have a step-by-step tutorial that covers how to make a bar graph in Excel 2016 for Windows and we show you how much faster and easier it is to make a bar graph in Instics.

Excel 2016 for Windows Tutorial (10 Steps)

Let's walk through the 10 steps required to make a bar graph in Excel.

Enter the data into Excel by typing it in or using copy and paste.

WARNING: Be careful to make sure that your X-Axis data does not have any repeating values. If you have repeating values, you will need to create a PivotTable first. We will show you how to do this in a future tutorial.
Select the data you entered by clicking on the top cell and dragging to the bottom cell.

WARNING: Be careful to only select the Y-Axis columns for the graph. In this example, we want Year on the X-Axis and iPhones Sold on the Y-Axis, so we only select the iPhones Sold column.
Click the Insert menu at the top.
Click the Insert Column or Bar Chart button in the Charts section.
Click the Stacked Column button in the 2-D Column section.
Click the Select Data button in the Data section of the Chart Tools Design menu.
Click the Edit button in the Horizontal (Category) Axis Labels section on the right.
Select the Year column data by clicking on the top cell and dragging to the bottom cell.

WARNING: Be careful to skip the column header. In this example, we skip the column header for Year and only select the X-axis values starting in row 2.
Click OK in the Axis Labels window.
Click OK in the Select Data Source window.

Finally, after following all of these steps, you will have a graph.

Instics Tutorial (1 Step)

Instics uses advanced automation algorithms to simplify this process to just 1 step to save you time.

Enter the data into Instics by typing it in or using copy and paste.

That's it! As you enter your data, Instics will automatically create graphs for you. Instics keeps your graphs organized on the right and you can click on one to zoom in.

Conclusion

At Instics, we are always looking for ways to help you save time. Our advanced Instics automation algorithm takes care of repetitive tasks like making bar graphs. That means that you get to spend more time on important work and less time on tedious spreadsheet tasks.

Learn more about Instics, the world's easiest spreadsheet, at instics.com.

‹ Latest entries