ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Scroll Bar from horizontal to vertical orientation (https://www.excelbanter.com/charts-charting-excel/119666-scroll-bar-horizontal-vertical-orientation.html)

Brad

Scroll Bar from horizontal to vertical orientation
 
I have a horizontal scroll bar in the lower left corner of a chart... not
linked to a macro, but to a cell value for its control.

I would simply like to convert it from its horizontal posture to a vertical
placement so that I can move it into another area on the chart's y-axis
border, one not blocking the x-axis dates.

I keep thinking the solution would be found in "Properties," but I don't see
a solution there.

My thanks in advance for a clue or a solution!

Cheers! Brad



Andy Pope

Scroll Bar from horizontal to vertical orientation
 
Hi,

The orientation of the control is dictated by the ratio of width to
height. Just grab a corner and make the control tall and thin.

Cheers
Andy

Brad wrote:
I have a horizontal scroll bar in the lower left corner of a chart... not
linked to a macro, but to a cell value for its control.

I would simply like to convert it from its horizontal posture to a vertical
placement so that I can move it into another area on the chart's y-axis
border, one not blocking the x-axis dates.

I keep thinking the solution would be found in "Properties," but I don't see
a solution there.

My thanks in advance for a clue or a solution!

Cheers! Brad



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 03:35 PM.

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