Then, in the popped out Axis Labels prompt box, select the cell A2:A6 as the Axis label range, see screenshot:Ģ5. In the chart, you can see the vertical axis label has been changed, to return the original axis label, please right click the chart area, and choose Select Data to go to the Select Data Source dialog box, in the opened dialog, click the Completion % from the Legend Entries (Series) list box, and then click Edit button from the Horizontal (Category) Axis Labels section, see screenshot:Ģ4. And then, click OK button, and the chart has been changed to the below chart, now, you should delete the secondary axis as you need, see screenshot:Ģ3.
SLIDER SLICER IN EXCEL SERIES
In the Change Chart Type dialog box, in the Choose the chart type and axis for your data series list box, change the chart type of the Helper 2 data series to Scatter, see screenshot:Ģ2. This step, please right click the new added data series (grey bar), and choose Change Series Chart Type from the context menu, see screenshot:Ģ1. Then, click OK > OK to close the dialogs, and the chart has been displayed as below screenshot shown:Ģ0. In the following Axis Labels prompt box, select B2:B6 as the Axis label range, see screenshot:ġ9. Then, click OK button to return the Select Data Source dialog box, in this dialog, please click Edit button from the Horizontal (Category) Axis Labels section, see screenshot:ġ8. In the popped out Edit Series dialog box, select D1 as the Series name, and select D2:D6 as the Series values, see screenshot:ġ7. Then, go on clicking to select the chart, and right click the chart area, choose Select Data from the context menu to go to the Select Data Source dialog box, click Add button, see screenshot:ġ6. Still in the Format Data Series pane, under the Fill & Line tab, from the Fill section, select Solid fill option, and then choose one darker green color from the Color drop down, see screenshot:ġ5. In the opened Format Data Series pane, under the Series Options tab, adjust the Series Overlap to 100%, and change the Gap Width to 120% as you need. Next, please right click the new added data series (orange bars), and choose Format Data Series, see screenshot:ġ3. Then, click OK > OK to close the dialogs, and you will get the chart as below screenshot shown:ġ2. In the popped out Edit Series dialog box, select cell B1 as the Series name, and select B2:B6 as the Series values, see screenshot:ġ1. In the popped out Select Data Source dialog box, click Add button, see screenshot:ġ0. And then, click to select the chart, right click the chart area, and choose Select Data from the context menu, see screenshot:ĩ. Then, right click the bar of the chart, and then click Fill, and choose one bright green color from the theme colors section, see screenshot:Ĩ. In the opened Format Axis pane, under the Axis Options tab, change the number to 1.0 from the Maximum text box, see screenshot:ħ.
Then right click the horizontal axis, and choose Format Axis option, see screenshot:Ħ. And a bar chart has been inserted, you just need to delete the unneeded elements, such as chart title, gridlines to get the following results:ĥ.
After creating the helper data, now, please select the data in column A and column C, and then click Insert > Insert Column or Bar Chart > Clustered Bar, see screenshot:Ĥ.
Note: In the above formula, the number 2 indicates the row number of your formula located, and then number 5 indicates that how many rows of your data (exclude the header row).ģ.
0 kommentar(er)
