ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I make two y axis in bar graphs (i.e. cross hatching)?? (https://www.excelbanter.com/excel-discussion-misc-queries/68074-how-do-i-make-two-y-axis-bar-graphs-i-e-cross-hatching.html)

ancientk

How do I make two y axis in bar graphs (i.e. cross hatching)??
 
Two y axis on a graph with one x axis.

Bill Martin

How do I make two y axis in bar graphs (i.e. cross hatching)??
 
ancientk wrote:
Two y axis on a graph with one x axis.


Just create your graph with Y lines on one axis. Then right click on the line
you want to move to a new axis on the right side and select FormatDataSeries.
From there click on the Axis tab then click the button that says SecondaryAxis.

Good luck...

Bill


All times are GMT +1. The time now is 08:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com