16 September 2016

How to create secondary Axis (Microsoft office excel 2007)

1. Create table 


2. Insert chart, select chart 


3. Chart only shown primary Axis 


4. Click on "layout" tab,
5. select Series "Percentage"
6. Click on "format selection "
7. "Format data series" shown select Secondary Axis



8. Select "Design" tab  then change chart type (click on selected graph) 


9. Click on "format tab" 
10. Select "secondary vertical value Axis" 
11. Click on "format selection "
12. "Format Axis" shown select change Maximum values.  



13. Done.


No comments:

Post a Comment