Stacked bar chart - adding connecting lines

J

Janetoes

In a 100% stacked bar chart - how do you create lines that connect from one
bar to another, so that every data point in a series is connected to the next
bar? When I right mouse click it says" format line series" and will let me
change the color or pattern. But I do not see any data for it in the data
sheet (just the plot numbers for the bars). Now I have to update the charts -
How do I recreate them?
 
A

Andy Pope

Hi,

Right click the series and pick Format Data Seris.
On the Options tab is the checkbox, Series lines.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stacked Bar Chart 1
How to make scroll bar permanently visible, Word 365 0
Line chart with dotted lines rendered poorly in presentation mode 0
sideways stacked bar charts with line series on the same axis 0
Filtered view of Visio Chart 0
Want to prevent one stacked bar from covering next stacked bar. 1
Stacked bar chart and Line 3
stacked bar chart - problem adjusting bar width - Excel 2007 0

Top