AJP Excel Information AJP Excel Information
 
 

RE: Point and Bar chart (MSGraph)

 

The chart is a stacked bar chart with a custom fill used to display the point.
The PadDot values in the data sheet will need to be adjusted in order to compensate for half of the Dot value
 
Once you have created the stacked bar chart you can format the 2 pad series to have no fill and no border.
The reason for two pad values is in case you want both point and bar on the same row, although the data values will not be allowed to overlap. In order to have overlaps you will need to move the PadDot and Dot series to the secondary axis.
To create the point in use an oval autoshape. Cut and Paste this to the Dot series.
See example presentation
   

Created August 2004
Last updated 5th August 2014 


Return to main page Chart Section VBA section Fun and games section Forum files Tips section Links section Book section Site information Site Search RSS feed Top of page


Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007-2014 Andy Pope