How to add lines between stacked columns/bars [Excel charts]
The image above shows lines between each colored column, here is how to add them automatically to your chart.
-
Select chart.
- Go to tab "Design" on the ribbon.
-
Click "Add Chart Element" button.
- Click "Lines".
-
Click "Series Lines".
Lines are now visible between the columns.
How to change line thickness
-
Click once on one line between columns to select them all.
- Go to tab "Format" on the ribbon.
-
Click on arrow to display all Shape Styles.
-
Select a line thickness and color.
- Hovering over a line and the chart shows a preview in real time.
Related articles
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: [โฆ]
Rearrange data source in order to create a dynamic chart
Fatou asks: Going back to my question, I had created a table and used the data to create a chart. [โฆ]
How to align chart with cell grid
This trick is so simple and also an incredible time-saver if you want to build beautiful worksheets or dashboards where [โฆ]
To be able to resize a chart you must first select it, you do that by left-click on the chart with [โฆ]
The image above shows you categories (countries) grouped into regions making this chart a lot cleaner and easier to read. How [โฆ]
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: [โฆ]
How to use mouse hover on a worksheet [VBA]
I recently discovered an interesting technique about using a user defined function in a HYPERLINK function. Jordan at the Option [โฆ]
Change chart data range using a Drop Down List [VBA]
In this article I will demonstrate how to quickly change chart data range utilizing a combobox (drop-down list). The above [โฆ]
How to create an interactive Excel chart [VBA]
This article describes how to create an interactive chart, the user may click on a button or multiple buttons and [โฆ]
Format fill color on a column chart based on cell color
Table of contents Format fill color on a column chart based on cell color Change stacked bar colors Mark Graveson [โฆ]
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
English
Spanish
