Basics of Excel Charts

by on May 2, 2017

Basics of Excel Charts In the previous article, we prepare the bar chart from our data. In this article, we will provide tips on how to change the settings of your chart according to your needs and requirements. Basics of Excel Charts is the first step to learn about charts and from there you can […]

how to add checkbox in excel

by on May 2, 2017

Adding Checkbox in Excel Add checkbox to your excel dashboard is a useful technique for data presentation and analysis. With the click of a button, your chart is ready. When checkbox is ticked, it will show TRUE in the cell to which it is linked and based upon the TRUE message the data will be […]

Overlapping Bar Chart

by on May 2, 2017

Overlapping Bar Chart Overlapping Bar chart is a chart in which Bars are overlapped each other (Image provided below). Our objective is to build the chart as provided below. Step 1: Select the data, and simply insert the simple bar chart from insert tab. Select the colors (Light blue for sales, Red for cost and […]

Gantt chart

by on May 2, 2017

Gantt chart Gantt chart is used as a project Management tool devised by Henry Gantt in 1910. The progress of the projects can be monitored through it. Students can use it to schedule their studies. In the short video below, you will be to learn simple Gantt Chart in excel. Gantt chart is a planning […]