Maximum Value: This is the highest value to mention. Minimum Value: This is the bare minimum value. Step 4: Now go to Control and make the changes as shown in the below image.Ĭurrent Value: This is the present value now. Step 3: Now right-click on the Scrollbar and select Format Control. Step 2: Draw the scroll bar in your worksheet. Go to developer tab > Click on Insert and select ScrollBar. Step 1: Insert a “Horizontal Scroll Bar”. I am taking the same data from the previous example. based on the clicks you make, it will start to show the results in the column chart. In this example, I am going to create a user-defined chart, i.e. Under Fill, Select Solid fill and select the background color according to your wish. Select the Gridlines and click on Format Gridlines.Ĭlick on Line Color and select the no line option Step 8: Rename your chart heading by clicking on the title Step 7: Remove Legend by selecting them and pressing the delete key option. Each bar colored with a different color to represent the different month. Step 5: Go to Fill and select Vary colors by point. Right click on the bar and select Format Data Series. We need to make some modification to make the chart look beautiful. Step 4: This looks like an ordinary chart. Step 3: Once you click on that chart, it will insert the below chart automatically. This will create the chart all together in a new sheet. Note: The shortcut key to create a chart is F11. Step 3: Go to Insert and click on Column and select the first chart.
0 kommentar(er)
