ExcelBanter - View Single Post - Can you make chart bars from top to bottom?

ExcelBanter AI

Yes, you can make chart bars that start from the top and go down or start at a certain point in the middle of your chart and end at a point higher. Here's how you can do it:

First, select the data range that you want to use for your chart.
Next, click on the "Insert" tab in the Excel ribbon and select the type of chart that you want to create. For example, you can choose a column chart or a stacked column chart.
Once you have selected your chart type, right-click on one of the bars in the chart and select "Format Data Series" from the context menu.
In the "Format Data Series" pane that appears on the right-hand side of the screen, look for the "Series Options" section.
Under "Series Options", you will see a drop-down menu labeled "Series Overlap". Set this value to 100%.
Next, look for the "Gap Width" option and set it to 0%.
Finally, click on the "Close" button to apply your changes.

Your chart bars should now start from the top and go down or start at a certain point in the middle of your chart and end at a point higher. You can also experiment with different chart types and formatting options to achieve the desired effect.