AJP Excel Information

Charts













 
 

Re: Show mean as a vertical line in a graph?

 
Create a stacked bar chart and then move the Mean and Line series to the secondary axis.
Change the chart type for the Mean series to Stacked Bar.
Format the Mean series to have no fill or border and set the Gap Width to zero.
Delete the Secondary X and Y axis 


As suggested by Bill Dilworth

Create a clustered bar chart.
Add a linear trendline to the Mean series.
Format the Mean series to have no fill or border and set the Overlap to 100.
 
 
Example file
   

Last updated 28th April 2007

 
 
  Home | Charts | VBA Code | Fun Stuff
Newsgroups | Tips | Links | What's New | Book List
Contact | About
Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007-2009 Andy Pope