ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   vertical scale on both ends of bar chart (https://www.excelbanter.com/charts-charting-excel/226725-vertical-scale-both-ends-bar-chart.html)

Midjack

vertical scale on both ends of bar chart
 
How can I put the vertical (y) axis scale on both ends of a bar chart? I
tried putting one of the series on the secondary axis, but that just plots
the secondary axis series on top of the primary axis data and in the center
of the chart. Using Select Data Source the secondary axis series would not
move either up or down.

Bernard Liengme[_2_]

vertical scale on both ends of bar chart
 
When you make a column chart the y-axis is generally to the left of the plot
area. If you add a seconday axis it noramlly goes to the right of the plot
area. It sounds as if you have adjusted the axis to be somewhere else. Try
making a new chart
best wishes
--
www.stfx.ca/people/bliengme


"Midjack" wrote:

How can I put the vertical (y) axis scale on both ends of a bar chart? I
tried putting one of the series on the secondary axis, but that just plots
the secondary axis series on top of the primary axis data and in the center
of the chart. Using Select Data Source the secondary axis series would not
move either up or down.



All times are GMT +1. The time now is 02:10 PM.

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