
The clicks you make on the scroll bar will start to show the bars in the column chart.Īs of now, I have clicked the scroll bar only 3 times, so it is showing only for 3 months. Step 7: Now, the COLUMN CHART has created. But here, select the rearranged data instead of the original data.

Step 6: Now insert a COLUMN CHART as shown in example 1. So like this, I have mentioned the formula for all the 12 months. Similarly, in cell F5, I have mentioned if cell C1 (scrollbar linked cell) is greater than or equal to 2, I want the value from cell B3 (that contains Feb month sales). In cell E5, I have mentioned the formula: If the cell C1 (scrollbar linked cell) is greater than or equal to 1, I want the value from cell B2 (that contains Jan month sales). I am applying the IF formula to rearrange the data. Step 5: Now, we need to rearrange the data to create a chart. Now you can check by clicking on the scroll bar. If I click on the scroll bar once in cell C1 the value will be 1 if I click on the scroll bar twice, it will show the value as 2 because it is incremented by 1. Incremental Change: This is once you click on the ScrollBar, what is the incremental value you need to give.Ĭell link: This is the link given to a cell.

I have chosen 12 because I have only 12 months of data to present. Maximum Value: This is the highest value to mention.

To show you the ropes, we need to start with some initial data. Here’s a quick list of where male/female pie charts may come in handy: The goal of such charts is not to make accurate or precise comparisons but to help the audience understand how constituent parts of the chart contribute to the overall picture. Add the Male/Female Icons OverviewĪ male/female pie chart depicts a part-to-whole relationship between (surprisingly!) men and women by dividing a circle into proportional segments.
