To add a vertical line to a horizontal bar chart in Excel, you can follow these steps:
- Select the chart by clicking on it.
- Click on the "Chart Elements" button (the plus sign icon) that appears next to the chart.
- Check the box next to "Axis Titles" to add the axis titles to the chart.
- Click on the vertical axis to select it.
- Right-click on the vertical axis and select "Add Vertical Line".
- In the "Add Vertical Line" dialog box, select the type of line you want to add (e.g. solid line, dashed line, etc.).
- Enter the value where you want the line to appear on the vertical axis.
- Click "OK" to add the line to the chart.
To add a vertical date line to a horizontal bar chart, you can follow these steps:
- Create a new column in your data that contains the dates you want to add to the chart.
- Select the chart by clicking on it.
- Click on the "Chart Elements" button (the plus sign icon) that appears next to the chart.
- Check the box next to "Axis Titles" to add the axis titles to the chart.
- Click on the horizontal axis to select it.
- Right-click on the horizontal axis and select "Format Axis".
- In the "Format Axis" pane, select "Date Axis" under "Axis Type".
- Select the date format you want to use.
- Click "Close" to apply the changes.
- Click on the chart to select it.
- Click on the "Insert" tab in the ribbon.
- Click on the "Shapes" button and select the line shape you want to use.
- Draw a vertical line on the chart where you want the date line to appear.
- Right-click on the line and select "Format Shape".
- In the "Format Shape" pane, select "Solid Line" under "Line Style".
- Adjust the line color, width, and other settings as desired.
- Click "Close" to apply the changes.