ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I make a vertical floating bar chart? (https://www.excelbanter.com/charts-charting-excel/152672-how-do-i-make-vertical-floating-bar-chart.html)

danke_shane

How do I make a vertical floating bar chart?
 
I want to make a floating bar chart in Excel, but I want the bars to be
orientated vertically rather than the horizontal default. In other words, I
want the range of the floating bars to be displayed on the y-axis rather than
the x-axis. Can anyone help me?

Shane Stamschror

Andy Pope

How do I make a vertical floating bar chart?
 
Hi,

You need to use a stacked column chart with 2 series.
The first series provides the 'float'. Format this series to have no fill or
border.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"danke_shane" wrote in message
...
I want to make a floating bar chart in Excel, but I want the bars to be
orientated vertically rather than the horizontal default. In other words,
I
want the range of the floating bars to be displayed on the y-axis rather
than
the x-axis. Can anyone help me?

Shane Stamschror




All times are GMT +1. The time now is 08:45 AM.

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