Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General PowerPoint Questions / February 2008

Tip: Looking for answers? Try searching our database.

Stacked bar chart - adding connecting lines

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Janetoes - 21 Feb 2008 14:41 GMT
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?
Andy Pope - 21 Feb 2008 19:18 GMT
Hi,

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

Cheers
Andy

> 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?

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.